🚀 go-pugleaf

Thanks Viatcheslav.

I 'll check it obligatory.
I never thought that it is possble to use parameter without (":"char)

Thanks.


"Vassiliev V.V." <news@vassilievvv.mtu-net.ru> �������/�������� � ��������
���������: news:3e00828c@newsgroups.borland.com...
> 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.
> >
> >
> >
> >
> >
> >
>
>