Re: How to use parameters in TADOQuery

Article View: borland.public.cppbuilder.database.ado

Article #3111

Back to borland.public.cppbuilder.database.ado Previous Next

#3111

From: Dmitry
Date: Wed, 18 Dec 2002 09:54

29 lines
2145 bytes

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

Technical Details

Message-ID: <3e004817@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!nntp2.aus1.giganews.com!nntp.giganews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!proxad.net!fr.usenet-edu.net!usenet-edu.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References:

<3dfecc40@newsgroups.borland.com> <3dfee4ba@newsgroups.borland.com> <3dff15d6@newsgroups.borland.com> <3dff66dd@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,d6b087b7370736cc
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-12-18 02:10:03 PST
From: "Dmitry" <programmer@mail.spbnit.ru>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3dfecc40@newsgroups.borland.com> <3dfee4ba@newsgroups.borland.com> <3dff15d6@newsgroups.borland.com> <3dff66dd@newsgroups.borland.com>
Subject: Re: How to use parameters in TADOQuery
Date: Wed, 18 Dec 2002 12:54:25 +0300
Lines: 35
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
NNTP-Posting-Host: 212.48.199.123
Message-ID: <3e004817@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1040205847 212.48.199.123 (18 Dec 2002 02:04:07 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!nntp2.aus1.giganews.com!nntp.giganews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!proxad.net!fr.usenet-edu.net!usenet-edu.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message