I have customer table. In that table, I want to update some field which are null or invalid.
for ex. in Customer table, I have 1000 record. In GUI, I have next, previous and update button.
If more than one user will work to update that record, How it will work.
Is it possible, if first user open 1st record then 2nd user open 2nd record and then again 1st user open 3rd record. means same record don't open with different user.
How it works?
If I write simple select and simple update then I know, update statement handling locking system. but in this scinerio more then one user can open same record with simple select.
Please, any body can guide me.
Thanks,
for ex. in Customer table, I have 1000 record. In GUI, I have next, previous and update button.
If more than one user will work to update that record, How it will work.
Is it possible, if first user open 1st record then 2nd user open 2nd record and then again 1st user open 3rd record. means same record don't open with different user.
How it works?
If I write simple select and simple update then I know, update statement handling locking system. but in this scinerio more then one user can open same record with simple select.
Please, any body can guide me.
Thanks,