True, it could be useful - but I think Jason would have to change the SQL
to make this work (since = is not the same as IS), hence the need to
reprepare. Jason, does TIBOQuery emulate TQuery in this case (or does
TIBQuery behave like TIBOQuery and differ from TQuery)?

Helen, any plans for Firebird to support 'SELECT * FROM TEST WHERE A = NULL'?
Set

At 10:05 09.01.2001 +0100, you wrote:

>> The only way to test is to specify
>> 'SELECT * FROM TEST WHERE A IS NULL'.
>
>That's true for explicit SQL statements but I think the same should be
>possible using a parameter. At least in Delphi's TQuery it works with
>Params[xx].Clear so I expected it from IBO, too.
>It's convenient because you don't need to change the SQL statement text and
>therefore Unprepare and Prepare again when looking for rows with NULL
>fields.
>
>Cheers,
>TOndrej