Subject Re: [IBO] IBO components - SQLWhereItems
Author Helen Borrie
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

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