Subject Re: select ... for update: bug or feature?
Author Alexander V.Nevsky <>
--- In, "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.