At 11:45 PM 30/01/2007, you wrote:

>Helen, thanks very much for the thorough and thoughtful response.
>Lesson learned. I've got the syntax straight now, but won't be using
>it within IBO components.
>
>My original post had to do with quick & dirty edits to data within the
>IB_SQL utility. A simple select in IB_SQL cannot be edited unless the
>"for update" clause is added. I'm pretty sure I got this tip from
>Jason at a Borland conference years ago. I tested it a few minutes
>ago in the latest version of IB_SQL and it still seems to be the case.

Ah, OK, now I know what you are talking about. In that app, the FOR
UPDATE clause is parsed like RequestLive in a TIB_Dataset and causes
the app under the hood to create XxxxSQL for the statement, i.e. to
make it "live". The same thing happens automatically in the IB_SQL browser.

Helen