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 188756 - SQL SINGLE RECORD COMMIT ERROR
Summary: SQL SINGLE RECORD COMMIT ERROR
Status: RESOLVED WORKSFORME
Alias: None
Product: db
Classification: Unclassified
Component: Show Data (show other bugs)
Version: 6.x
Hardware: PC Windows XP
: P3 normal (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-07-19 05:53 UTC by fahadonline
Modified: 2010-07-19 10:40 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
SQL BUG SCREEN SHOT (74.62 KB, image/jpeg)
2010-07-19 05:54 UTC, fahadonline 		Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description fahadonline 2010-07-19 05:53:39 UTC 
Well when i run below mentioned query in sql editor it shows desired results as shown in attached screen shot, but when i modify the single column and row result and commit the changes, the net beans SQL editor updates all the row in the offers table instead of just updating the record with id = 123465

"select url from db_main.offers WHERE id = '123465'"
Comment 1 fahadonline 2010-07-19 05:54:43 UTC 
Created attachment 100910 [details]
SQL BUG SCREEN SHOT
Comment 2 Jiri Rechtacek 2010-07-19 10:40:15 UTC 
It works correctly, Data Grid editor modifies only one record, not more. Probably your change broke any other rule your table (primary key, unique index).