|Re: [IBO] TIB_UpdateBar problem ...
> 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
- - - - -
A "live" request only imposes this if you set SearchedEdits to false
are using a TIB_Cursor component. Otherwise, IBO actually suppresses
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