hi,
to explicitly lock a row (or rows), use :
BEGIN TRAN
select ... from ... where ... FOR UPDATE;
update ...
COMMIT TRAN;
Mathias
Selon Mohammed Sameer <[EMAIL PROTECTED]>:
>
> need some urgent help
>
> im using InnoBD database type...i need to explicitly lock a row and keep it
> locked until
need some urgent help
im using InnoBD database type...i need to explicitly lock a row and keep it
locked until i explicitly unlock that row..
it would be great if u could provide me with sql statements as a solution for
the above...
thanks