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?

--- In firebird-support@yahoogroups.com, Tim Ledgerwood <tim@s...>
wrote:

> At 11:08 AM 28/04/2004, you wrote:
>
> >We have solved the problem (sort of) and caused another. The
> >database was registered incorrectly in IB Expert (using the
> >Interbase client dll and not FB client dll). Thanks for your help
> >and to Tim. The query select first... does now work in IB Expert,
> >but not from our delphi application. We are using the Interbase
> >components in Delphi, which I assume is the problem. Is there any
> >possible way to fix this?
>
> Hi Adele,
>
> I can't help you with the second problem, but what is the SQL that

you are

> using in the query?
>
> I am successfully using the IB components with D5 with Firebird

1.5, after

> moving over from IB 6.02, and have found no problems moving over.
>
> Regards
>
> Tim
>
>
> [Non-text portions of this message have been removed]