This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 169430

Summary:	DELETE instruction limited to the pager limit
Product:	db	Reporter:	neuros_nid <neuros_nid>
Component:	SQL Editor	Assignee:	Jiri Rechtacek <jrechtacek>
Status:	RESOLVED DUPLICATE
Severity:	blocker
Priority:	P3
Version:	6.x
Hardware:	PC
OS:	Windows Vista
Issue Type:	DEFECT	Exception Reporter:

Description neuros_nid 2009-07-29 10:23:43 UTC

When clicking on "View Data" on a table, and executing an SQL instruction like "DELETE FROM 'table' WHERE field='foo'" 
(or even just "DELETE FROM 'table'"), only 20 elements are deleted. It seems limited to the "Page Size" value.

I'm working under an MSSQL database, and connecting using Microsoft JDBC driver 2.0 (I remember NB 6.5 behaved the 
same, with MS JDBC 1.0, 1.2).

Product Version: NetBeans IDE 6.7 (Build 200906241340)
Java: 1.6.0_14; Java HotSpot(TM) Client VM 14.0-b16
System: Windows Vista version 6.0 running on x86; Cp1252; fr_FR (nb)
Userdir: C:\Users\Degardin\.netbeans\6.7

Comment 1 Jiri Rechtacek 2009-07-29 10:29:35 UTC

I guess it's a duplicate of issue 168812. Already fixed in NB6.8. The fix should be a part of NB6.7 Patch1.

*** This issue has been marked as a duplicate of 168812 ***