🚀 go-pugleaf

ADO Express replaces :variable with ? in SQL query, so you need to use 2
different but equal parameters.

----------------------------------------------------------------
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:3dfecc40@newsgroups.borland.com...
> Hello ALL,
>
> I want to use mechanism of automatic substitution of parameters
> in Query, which VCL allows to do without code writing.
>
> I.e i use parameters in subordinated query with parameter names
> exact as needed fields in master query and assign Datasorce property
> of the TADOQuery to datasorce of master query.
>
> My problem is that, if i use in the query  parameters with the same name
> twice, the VCL apply  only first one and don't use the other.
> For example:
>
> SELECT * FROM detail_table WHERE address_id =:id AND something else
> is equal =:id
>
> It doesn't work on a practice, because VCL apply
> only first :id parameter.
>
> Do someone know what to do in the situation?
>
> P.S.
> I use MS Access database.
>
> --
> Best regards,
>  Dmitry                          mailto:programmer@mail.spbnit.ru
>
>
>
>