how to prevent deleting during edit?

[zin]

Howdy,

I have a table with 5 fields. User1 connects to the db
and is editing his dataset - say record 3. User2 connects
to the same db and wants to delete record 3 from his
dataset while user1 is editing the same record in his
dataset. How can I prevent User2 from updating the table
with the delete while user1 is still editing the record?

Thanks,
zin

 

[Guest]

Not gonna happen natively. With a dataset, once you pulled down the data, even if you leave the connection open (which you don't want to do), it's over. I think you are probably going to have to handle concurrency exceptions and have some user intervention which, is ex post facto but I think the only feasible solution in a disconnected architecture