Subject Re: [Firebird-Architect] gpre does not recognize WITH LOCK
Author Nickolay Samofatov
Hello, Klement,

> gpre does not know about the new keyword LOCK.

> However it accepts "SELECT x FROM tab WHERE recid=4711 FOR UPDATE WITH".

> It should also compile "... WITH LOCK".

GPRE has a separate SQL parser that was not updated with support for
the newest features. Do you really use GPRE in development ?
Anyway, adding support for this particular feature is a matter of
10-20 lines of code (parse WITH LOCK and generate BLR code to set
appropriate RSE flag). So feel free to send your patches to fb-devel or
to me directly. They will be reviewed and applied if cleanly
implemented.

> Guenther

--
Nickolay Samofatov