> I would not recommend using the FOR UPDATE clause with dynamic SQL.

Just to add an explanation around this...

**IF** the 'FOR UPDATE' clause was always passed with the dynamic SQL
to the server, then there may be a performance impact - due to the way
records are packed for network transfer.

However IBO is pretty smart - to quote Jason from an earlier
posting...

- - - - -
A "live" request only imposes this if you set SearchedEdits to false
and you
are using a TIB_Cursor component. Otherwise, IBO actually suppresses
the FOR
UPDATE part of the clause when sending the statement to the server.
- - - - -

So it may not be wise to get used to using FOR UPDATE, since it is a
bad habit should you ever move a product without the built-in smarts
of IBO. However I often use it when writing my SQL as a simple way of
getting RequestLive set to true while writing my SQL - and it is also
convenient to provide an indication of intentions while viewing SQL
statements.


Geoff Worboys
Telesis Computing