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.
Summary: | [67cat] Cannot delete all records at once using starts with query | ||
---|---|---|---|
Product: | db | Reporter: | rajivderas <rajivderas> |
Component: | DB schema | Assignee: | Jiri Rechtacek <jrechtacek> |
Status: | RESOLVED INCOMPLETE | ||
Severity: | blocker | CC: | jkovalsky |
Priority: | P3 | ||
Version: | 6.x | ||
Hardware: | PC | ||
OS: | Windows XP | ||
Issue Type: | DEFECT | Exception Reporter: |
Description
rajivderas
2009-04-02 11:51:53 UTC
I don't understand the problem. If I delete records in a table in SQL editor, it applies on all records conforming my condition and removed all of them. Are you using SQL editor too? Or you are using some embedded language editor, a PHP perhaps? Why did you set P2 priority? IMHO it's doesn't conform http://wiki.netbeans.org/BugPriorityGuidelines >>I don't understand the problem. If I delete records in a table in SQL editor, it applies on all records conforming my condition and removed all of them. follow the steps again here i have tried to delete 30000 records in a remote database(ms sql server 2008) where i wanted to delete records that starts with some string text(ex:'LTEST') and when i performed the delete the execution window states executed successfully but when i again query that same db table only about 20 records are deleted from those records and i had to execute the delete command for n number of times but i went to the remote server where the db server is and from its sql editor i executed the same query and it deleted all the matching string text records from the database. >>Are you using SQL editor too? Or you are using some embedded language editor, a PHP perhaps? i used the netbeans sql editor where i got this bug >>Why did you set P2 priority? IMHO it's doesn't conform Product feature doesn't work, a workaround exist but it's difficult to use or impractical (you can manually delete from db server editor) but you have to always log into the remote server to do this Reassigned to new owner. |