At 05:04 PM 11/09/2006, you wrote:

>--- 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.

I'm even more baffled than you think *you*are.

>Is not the result of a TIBOQuery a dataset?

No, TIBOQuery is a class that encapsulates a SELECT statement. The
result of a SELECT statement is a dataset.

>It has an OnNewRecord event handler.

Indeed. OnNewRecord is an event that fires when the Insert() method
of the dataset is called. If there is no dataset, there is no
OnNewRecord event.

>Also, the SQL code I posted was in the insert window of the TIBOQuery.

What is "the insert window"?

>Can I just modify the code in the insert window to achieve what I want?

I don't know. Could you describe this "insert window" ?

Helen