At 03:37 AM 30/08/2003 +0000, you wrote:

>Dear All,
>
>
>Which property of IB_Query contains the *final* SQL statement that is
>sent to the server?
>
>I have tried the SQL.Text + SQLWhere but they did not include the
>where items that I added in the OnPrepareSQL event.
>
>Or, is there a quick way to assign the *final* prepared SQL statment
>from IB_Query to IBO_Query?

Yup. (IBOQuery, btw, not IBO_Query!)

IBOQuery1.AssignSQLWithSearch(IB_Query1);

Helen