> -----Original Message-----
> The pessimistic lock of ADO may not be supplied properly by
> the driver vendor. One way to do it, is to do a dummy update
> statement of the records you would like to lock. This will
> keep anyone else from being able to update them until you commit.
>
> Jason
>
> kevtey wrote:
> > hie im new in firebird. i would like to know how can i impliment
> > record locking in firebird? can anyone pls enlighten me pls...

You can also use SELECT blah FROM TABLE WITH LOCK, or something similar,
which locks the records until the transaction is committed/rolled back.

Rgds

Si Carter
http://www.fbtalk.net/ - Web Based Firebird Forum
http://sourceforge.net/projects/fbutils - FBUtils
http://sourceforge.net/projects/dnfBB - Web based, Firebird Powered Forum