At 10:21 AM 05-11-02 -0500, you wrote:

>How can I show you what SQL is "actually going across the wire"? Also, if I
>don't have any KeyLinks defined, how can I show you what KeyLinks are being
>imposed?

Drop an IB_SQLMonitorDialog on your form and call its Show method in your
FormCreate. You can use copy/paste to transfer the SQL statement which IBO
presents to the API at Prepare time.

You *need* to have KeyLinks defined. Inspect the KeyLinks property to see
what IBO's "best guess" is - but it won't be correct, because of the joins
and the error you are getting involving a column that is not in your query.

Helen