In FB 1.5. Release Notes in C:\Program Files\Firebird.1.5.1\Docs

SELECT ... FROM <sometable>
[WHERE ...]
[FOR UPDATE [OF ... ]]
[WITH LOCK]
....;

----- Original Message -----
From: "xuxu" <xufh@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, October 19, 2004 8:25 PM
Subject: [firebird-support] How to lock data?



Hello！

How can I lock a row of a table in a FireBird 1.5 procedure ?
I want to lock the row that I selected for update.
like:
select * from my_table where id =1
for udpate;
update my_table where id = 1;


　　　


　　　　　　　　xuxu
　　　　　　　　xufh@...
　　　　　　　　　　2004-10-20


[Non-text portions of this message have been removed]





Yahoo! Groups Links