At 05:15 PM 24/04/2005 +1000, you wrote:

> > At 04:30 PM 24/04/2005 +1000, you wrote:
> >
> > >I'm converting an old BDE app and thus using IBO components.
> > >I have a lost of filter code I'd like to switch over to SWL if possible.
> > >I can't, however,seem to get SQLWhereItems to successfully add items and
> > >refresh the query.
> > >Is this property active (it's certainly available in IBO) but
> > appears to be
> > >dead (unlike IB_ components) maybe there is a different way I
> > need to use
> > >them?
> >
> > It should be just the same. Use the OnPrepareSQL event to clear the old
> > SQLWhereItems and add your new ones. "Refresh the query" is not quite
> > "it", since you need to call InvalidateSQL (you'll probably have to cast
> > your IBOQuery as IBODataset for this) to start the ball rolling; then
> > Prepare; then apply the values for the new params in the
> > BeforeOpen; then
> > Open.
> >
> > Helen
> >
>
>no luck - I wonder if cached updates has a hand in this?

I expect so. If the dataset is cached then you'll have to uncache it (via
ApplyUpates/CancelUpdates) before you can invalidate the SQL. If you use
ApplyUpdates, follow it up with Commit on the transaction and then
CommitUpdates to clear the cache.

Helen