--- In ib-support@yahoogroups.com, "leu57 <Rainer.Leopold@s...>"
<Rainer.Leopold@s...> wrote:

> Hi,
>
> though a 'select ... for update' statement is allowed in
> SQL and accepted outside an 'declare cursor' statement, it has no
> effect on locking the selected row[s] as it has e.g. in ORACLE.

Leopold, Select For Update is used in Firebird to make non-buffered
fetches - one row for one client request, not for locking. AFAIK this
feature is ignored by all high-level Delphi/BCB components. In FB1.5
which is now in beta state syntax and behaviuor is extended to Select
For Update [With Lock].

Best regards, Alexander.