🚀 go-pugleaf

For me (tested in D7, BCB6) this works (Northwind database is used):

Master query:

Select * from customers

Details query:

Parameters CustomerID VarChar(50);
Select * from Orders O
where (O.CustomerID = CustomerID) and (O.ShipAddress > CustomerID)

CustomerID in details query is parameter - but it has Access syntax, not
Borland (no ":" char). To make it work you may need open Parameters property
dialog and display parameter properties. Set also TADOQuery.Prepared to
True.

Please not that this query syntax is MS Access specific and most probable
will work only with Jet databases.

----------------------------------------------------------------
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:3e004817@newsgroups.borland.com...

>
> > 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
>
> Dear sir.
> I usderstand. But my goal is not write special code for assigning of
> parameters.
> I'm talking just about case of assigning Datasorce property to TADOQuery.
> In this case when master dataset scrolls, VCL will automatically
substitute
> parameters in detail dataset IF names of some fields in master dataset are
> equal to names of parameters. AND You know about that.
> But the problem of this example is that it will not work in such mode
> because
> VCL will assign only first parameter.
>
> Can you tell, do your components solve this problem.
>
> P.S
> I use Assess
> Sincerely yours.
> Dmitry.
>
>
>
>
>
>