Subject Re: [IBO] preparing query
Author Ronaldo Rezende Vilela Luiz
I don't do this with parametes because before I set the value for parameters
I want all the registers of the table. If I don't assign values for
parameters I will have all registers of the table?


--
Ronaldo Rezende
ronaldim@...
-----------------------------------------
Analista e desenvolvedor de sistemas
e solu��es Desktop, Client / Server,
Internet, Intranet.
Uberaba, MG - Brasil
2� Per�odo de Sistemas de Informa��o
Universidade de Uberaba
....
""Helen Borrie (TeamIBO)"" <helebor@...> escreveu na mensagem
news:5.1.0.14.0.20020424001615.05f82ec0@......
> At 11:01 AM 23-04-02 -0300, you wrote:
> >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.
>
> Sorry, but you can't do that. SQLWhereItems actually changes the
> specifications of the query: you use it to change columns of the
selection
> criteria. That causes the query to get unprepared. Therefore,
> OnPrepareSQL is the *only* place where you can alter SQLWhereItems.
>
> If you only want to change the values of existing parameters, then don't
> use SQLWhereItems - it is not what you want. Use ParamByName() or Params[]
> in the BeforeOpen event. In this case, if the query is already prepared,
> it doesn't need to be prepared again...ParamByName() will do a Prepare if
> one is needed but you must always call Prepare before calling Params[].
>
>
> regards,
> Helen Borrie (TeamIBO Support)
>
> ** Please don't email your support questions privately **
> Ask on the list and everyone benefits
> Don't forget the IB Objects online FAQ - link from any page at
> www.ibobjects.com
>
>
>
>
___________________________________________________________________________
> 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/
>
>
>