All locks are released when you commit your transaction.
> boolean Got = false
> while Got == false
> Start transaction
> SELECT * FROM syslock WHERE id=%d AND used='f' FOR UPDATE
the row is locked here ...
> if SELECT returns a row
> then
> UPDATE syslock SET used='t' WHERE id=%d
> Commit transaction
... and released again here; probably not what you want
> Got = true
> else
> Rollback transaction
> continue // yes, active wait ... I'm testing !
> end if
> end while
> Trace "I get the syslock number %d !!"
> Do something with the syslock %d which is now reserved
> UPDATE syslock SET used='f' WHERE id=%d
should move your "commit transaction" here
have fun
helge
