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
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
> 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
> >apply the sqlwhereitems after the user perform a buttonclick. My
> >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
> 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
> IB Objects - direct, complete, custom connectivity to Firebird or
> without the need for BDE, ODBC or any other layer.
> - your IBO community resource for Tech Info
> keyword-searchable FAQ, community code contributions and more !
> Your use of Yahoo! Groups is subject to