Yes, look into the InvalidateSQL property , SQLWhereItems property,
OnPrepareSQL event.

There are some examples to look at like the Contact sample application.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "Florian Hector" <FHector@...>
Newsgroups: egroups.ibobjects
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, November 27, 2002 11:30 PM
Subject: [IBO] One query for many conditions?


> In an application I want to give the user the possibility to show only
part
> of the existing data, e.g. only the rows where a boolean field is true or
> only the rows where a field with optional remarks is not NULL, in other
> words where the WHERE clause of the SQL string has to change.
> Is there an elegant way to do that with IBO, other than assigning a
> completely different SQL property to the query?
>
> Florian