At 11:32 AM 28/04/2004, you wrote:

>Thanks for your help Tim. The query is a standard "select first"
>query. If I take exactly the same query text and I run it from IB
>Expert it works fine.
>SELECT First(100) * from MyTable.
>
>Do you use the select first... query in you D5/FB1.5 combination?

No - all my code (SQL) is IB 6.02 "compliant". I use the ibclient dll
facility included in the FB distribution - I understand that it passes all
the SQL to the FB engine, and I have had no problems with it. In other
words, I don't work directly with the fbclient dll.

Regards

Tim


[Non-text portions of this message have been removed]