I've been reading around and I seem to get the impression that Row, Page & Table locks are only held for the duration of a transaction.

The system I’m trying to investigate to see if it would work like so…

+ User logs in

+ User request some records to modify

+ These are selected from the database and the rows are lock (App connects to database, retrieves and locks rows, disconnects)

+ The user modifies this data, taking say 30mins

+ User click update on the GUI and the changed data is saved to the database and the locks release (App connects to database, saves the data down, unlocks the records, disconnects)


Is this even possible?????