Subject Re: [IBO] preparing query
Author Daniel Rail
At 04/23/2002 10:26 AM, you wrote:
>What I must do after SQLWhereItems.Add ? When I put a refresh, the registers
>aren't goint to filter. I thinked that the refresh did a close and a open
>metod in a dataset. When I close the form I must to use a
>SQLWhereItems.Clear ? What I must to do to apply the sqlWhereItems ?

Put the SQLWhereItems.Add in the OnPrepareSQL event(the only place where
SQLWhereItems should be used). Call SQLWhereItems.Clear at the beginning
of the event. And before calling Refresh, call InvalidateSQL.

Daniel Rail
Senior System Engineer
ACCRA Group Inc. (
ACCRA Med Software Inc. (