--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@...> wrote:

> >I have read that perhaps I should use the OnNewRecord event
>
> Nope. OnNewRecord is an event of a dataset.

Apologies for being baffled.

Is not the result of a TIBOQuery a dataset? It has an OnNewRecord
event handler.

Also, the SQL code I posted was in the insert window of the TIBOQuery.
Can I just modify the code in the insert window to achieve what I want?

Mitch