Front-end/Back-end Locking

J

Jerry315

I have an A2K application that I have split into a FE/BE
solution. The forms in the FE are not bound to a table
instead I use listboxs and text fields with SQL code
behind to do adds, deletes and updates. How do I lock the
record that a user has selected in the listbox so that no
one else can modify while they are editing? Do I add
begin/end transaction code around my SQl code?

Thanks in advance for any assistance!
Jerry
 
Top