Subject Re: [IBO] query with NULL parameters
Author Daniel Rail
At 28/02/2002 04:36 PM, you wrote:
>I have a query like this:
>select * from table1 where field1=:param1 and field2=:param2 and .... and
>While the SQL text takes into account all the possible filters, very seldom
>I need to use them all.
>I wonder what happens if some parameters are left NULL.
>Will the query still work w/o taking into account the NULL parameters ?

The NULL parameters are taken into consideration and return the records
matching your request, even those with NULL.

If you want to modify the WHERE clause of a query, then use the
SQLWhereItems property to easily modify the WHERE clause. And, I normally
do this within the OnPrepareSQL event.

Daniel Rail
Senior System Engineer
ACCRA Group Inc. (
ACCRA Med Software Inc. (