Hi,

> I think you did't understant my sql statement.

> if I pass 999999 to parameter Id, Query returns all records.

> Parameter ID=9999999 ==> Returns all records
> Parameter ID=1 ==> Returns Only id=1 records.


> I often use this property.
> This sql statement is very useful for me.

I tried a similar query and it works for me, with Firebird 1.0 and
using IB Objects.

One question: What version of Firebird are you using?


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)