You do this by invalidating the SQL when the InvalidateSQL method is called
and then you Refresh the dataset. In the process of refreshing it will
trigger the OnPrepareSQL event and bring back the dataset according to the
new Where clause.

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

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


"Florian Hector" <FHector@...> wrote in message
news:atq92r$va3$1@......

> Hi All,
>
> I have a little problem understanding the usage of SQLWhereItems. From

what

> I found in the Getting Started Help file and here on the list I understand
> that it can use only be used in the PrepareSQL event, which I cannot

change

> dynamically at runtime. How can I add and later remove a completely new
> WHERE clause at runtime?
>
> Florian