Subject Re: [firebird-support] Locking records in stored procs
Author Jerome Bouvattier

> b) select them FOR UPDATE WITH LOCK, in concurrency isolation

Could you explain what is the difference between WITH LOCK and FOR UPDATE

I read the release notes, but I'm not sure I got it clear.
What I understand is that FOR UPDATE has for consequence to fetch the result
set row by row instead of X rows at once, hence limiting the number of
(useless) locks at the cost of an increased fetching time.

Am I right ?

Also, what is the purpose of the OF <column name> option ?

Thanks a lot.