Re: Record Locking using web forms ?

Atif Ahmad Khan <aak2_at_Ra.MsState.Edu> wrote in article
> 2. Every row be assigned a serial number that is incremented by 1 everytime
> it is updated. Then that serial number is forwarded to the user as hidden
> field like in the above example. If the user wants to update it then the
> 2 serial numbers are compared. (This sound like a little less complicated
> in theory).

In Sybase you have a datatype called timestamp. This is a column that is changed by the database each time the record is changed.
Each record in a table has a unique timestamp value.

Example:

1. User1 select the record he get the current timestamp: 0x1
2. User2 select the record and he too get the same timestamp: 0x1
3. User1 change some data and save:
	update Table 
	set ....
	where timestamp = 0x1

	update Table 
	set ....
	where timestamp = 0x1

Stein-Tore Received on Wed Sep 18 1996 - 00:00:00 CEST