Subject | Re: [IBO] preparing query |
---|---|
Author | Daniel Rail |
Post date | 2002-04-23T13:43:39Z |
At 04/23/2002 10:26 AM, you wrote:
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. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)
>What I must do after SQLWhereItems.Add ? When I put a refresh, the registersPut the SQLWhereItems.Add in the OnPrepareSQL event(the only place where
>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 ?
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. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)