Re: Record Locking using web forms ?

In article <aak2.842442903_at_Isis.MsState.Edu>, aak2_at_Ra.MsState.Edu (Atif Ahmad Khan) wrote:

> Record locking using web forms ?
 

> 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

If your form calls a stored procedure, or a table directly, create a table column of type 'timestamp' if will be changed automagicly every time a change happens to the table. So when your update happens like

update {table}

set a = _at_a

where key = _at_key AND TIMESTAMP = @TIMESTAMP

RJ

Randy Jordan                                 Senior Systems Analyst
                                             SRI International
(408) 735-1175                               (415) 859-4625
rw_jordan_at_interramp.com                      rjordan_at_unix.sri.com
                                             http://mis.sri.com/rjordan/
------------------------------------------------------------------------