Subject RE: [IBO] IBO components - SQLWhereItems
Author Alan McDonald
> 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?