Hey
I would like to tell you a little feature, what would be nice, if you could implement it.
That the Wizzard can create Update Commands with RowVersion, by using the DataAdapter.
THX
Something for the Wishlist
-
- Posts: 729
- Joined: Thu 13 Dec 2007 10:24
Hey
What I mean is, the following situation:
I make a Select Statement with an DataAdapter. - I bind the DataAdapter to a Dataset. - This DataSet is showed to the user through a grid.
The application is a network active application. - & so somehwere else changes some data in the database.
Now the user, who sees the DataGrid, wants also to update the same Data. - And with the update command generated now, it would be updated. - But if there would be rowversion check, the will be told, that the Data he sees, is not up to date.
like the code above - Till yet, I have to do it by hand
What I mean is, the following situation:
I make a Select Statement with an DataAdapter. - I bind the DataAdapter to a Dataset. - This DataSet is showed to the user through a grid.
The application is a network active application. - & so somehwere else changes some data in the database.
Now the user, who sees the DataGrid, wants also to update the same Data. - And with the update command generated now, it would be updated. - But if there would be rowversion check, the will be told, that the Data he sees, is not up to date.
Code: Select all
UPDATE `row_version` SET `id` = :id, `value` = :value, `version` = :version WHERE ((`id` = :Original_id) AND ('value' = :Original_value) AND (`version` = :Original_version))
-
- Posts: 729
- Joined: Thu 13 Dec 2007 10:24