>
> 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

still no go - remind what the difference between SQLWhere and SQLWhereItems
is?
Alan