W
wrxguru
Hi, I have an application where a group of tables are updated.. one of
the table (product) holds the latest product number .. to find the
latest prod # i just use a sqlreader then when i find the latest # i
add one to it. i then insert it via a dataadapter/dataset. i then
go to execute the sqlready to find the next latest and find it is
locked out of the whoel table no matter what level of isolation i
use.
all of these updates are in a transaction becuase i want to back them
out if i strike any problems. is it possible to read table rows
alread updated/inserted in the same transaction ?
regards Robin
the table (product) holds the latest product number .. to find the
latest prod # i just use a sqlreader then when i find the latest # i
add one to it. i then insert it via a dataadapter/dataset. i then
go to execute the sqlready to find the next latest and find it is
locked out of the whoel table no matter what level of isolation i
use.
all of these updates are in a transaction becuase i want to back them
out if i strike any problems. is it possible to read table rows
alread updated/inserted in the same transaction ?
regards Robin