🚀 go-pugleaf

>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
>
>
>
>
>
>
>
>
>
>
>
>