History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: DBN-1
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Dan Cioca
Reporter: Dan Cioca
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Database Navigator

Data editor does not match rows correctly after insert operation

Created: 11 Dec 07 13:42   Updated: 11 Dec 07 13:42
Component/s: Dataset Editor
Affects Version/s: None
Fix Version/s: None

Original Estimate: Unknown Remaining Estimate: Unknown Time Spent: Unknown

Build: 117


 Description  « Hide
Background:
Data editor rebuilds the underlying result set after a row has been inserted in order to be able to edit the data in the newly inserted row. This approach may need review, but so far it is the only way to accomplish that, since result set can not scroll to the newly inserted rows. Using CachedRowSet was not an option, since this does not provide interactive input validation against database constraints.

When rebuilding the data editor model, the system tries to match the old model rows, to be able to highlight the changes. If the table or view has primary or unique key columns, the matching is done only on these columns, which ensures the right row is matched. If the dataset has no primary or unique key, the matching is done on all values of the row, matching which typically fails in case the row has been updated by a trigger after insert.



 All   Comments   Work Log   Change History      Sort Order:
There are no comments yet on this issue.