>
> When I run the sql directly in the sql editor it works fine..
>

I also experienced strange problems with IBX (version 7.08) as a
driver between Delphi 7 and FireBird v 1.5. When I switched over to
IBOjects these problems vanished. You are welcome to phone me for a
detail discussion (in Afrikaans) about my experience with Delphi,
IBObjects, ReportBuilder, IntraWeb, TeeChart Pro, Rubicon etc. I'm at
The Council for Geoscience, Silverton, Pretoria. Office number:
(012)841-1067

Groete,

Nols Smit