I can't put on the onprepared event because the query is open and I want to
apply the sqlwhereitems after the user perform a buttonclick. My statments
is created automatically according the user choose the options in the
program.
....
"Daniel Rail" <daniel@...> escreveu na mensagem
news:5.1.0.14.2.20020423104126.03ed5008@......

> 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. (www.accra.ca)
> ACCRA Med Software Inc. (www.accramed.ca)
>
>
>
>

___________________________________________________________________________

> IB Objects - direct, complete, custom connectivity to Firebird or

InterBase

> without the need for BDE, ODBC or any other layer.
>

___________________________________________________________________________

> http://www.ibobjects.com - your IBO community resource for Tech Info

papers,

> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>