🚀 go-pugleaf

SELECT * FROM detail_table WHERE address_id =:id AND something else
is equal =:id2

ADOQuery->Parameters->ParamByName("id")->Value = SomeValue;
ADOQuery->Parameters->ParamByName("id2")->Value = SomeValue;

Mark Guerrieri
mguerrieri@cmsgrp.com

"Vassiliev V.V." <news@vassilievvv.mtu-net.ru> wrote in message
news:3dff66dd@newsgroups.borland.com...
> >But if need in query two parameters i have to create
> > fake field in master query by means AS (alias) and use the alias as
second
> > parameter(with the other name) in subordinated query.
>
> Parameter is not field and fields are not directly related with
parameters.
>
> In Access you can define parameters inside query (that is not BDE-like
> syntax ":param" that is supported by ADO Express).
> Your query will look like:
>
> Parameters Param1 Int;
> SELECT * FROM detail_table WHERE address_id =Param1 AND something_else
> =Param1
>
> ----------------------------------------------------------------
> Regards,
> Viatcheslav V. Vassiliev
> http://www.oledbdirect.com
> The fastest way to access MS SQL Server, MS Jet (MS Access)
> and Interbase (LCPI provider, http://ibp.lcpi.lipetsk.ru) databases.
>
> "Dmitry" <programmer@mail.spbnit.ru> �������/�������� � ��������
���������:
> news:3dff15d6@newsgroups.borland.com...
> >
> > > ADO Express replaces :variable with ? in SQL query, so you need to use
2
> > > different but equal parameters.
> >
> > Yes but in this case i need to write code and manually assign parameters
> > before activating
> > query.
> > What i like now is that i dont need to write code for subordinated query
> if
> > use
> > only one parameter. But if need in query two parameters i have to create
> > fake field in master query by means AS (alias) and use the alias as
second
> > parameter(with the other name) in subordinated query.
> >
> > It is not nice for me.
> > I interested if there is special methodics for that.
> > Maybe somethere there is event where it is possble to deal with
parameters
> > before dataset activating?
> > Maybe there is some ADO Express descendant components which decide this
> > problem?
> >
> > My goal is not to write specific C++ code and use visual possibilities
of
> > Builder.
> >
> > Dmitry
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>