> If I set SKIP_ROWS to 0 and PROJECT_CATEGORY to 1 the dataset will
> be empty, but if I set SKIP_ROWS to 1 and PROJECT_CATEGORY to 1 one
> row is returned correctly.
> If I remove the WHERE condition it works fine.
> I noticed that PROJECT_CATEGORY parameter is recognized as an INT64
> and that if I remove the SKIP_ROWS parameter and set the value in
> the sql statement everything works fine.

> Am I missing something or is it a bug?

What you are missing is sufficient information...

I just ran this against FB WI-V6.2.794 Firebird 1.0
using IB_SQL built with IBO v4.2.Hd running on Win2000 SP2.

SELECT FIRST 1 SKIP :Skip * FROM COUNTRY
WHERE CURRENCY STARTING :Prefix
ORDER BY COUNTRY

It appears to work exactly as I expect. Obviously I cant reproduce
your exact situation here (I dont have a table with the same records
that I can try using project category parameter).

If you can reproduce the problem in a simple database - and prove to
yourself that exactly the same statement works with IBExpert and not
with IBO, then send the database to Jason or myself and we can take
a more detailed look.

--
Geoff Worboys
Telesis Computing