Article View: borland.public.cppbuilder.database.ado
Article #3099Re: How to use parameters in TADOQuery
From: Dmitry
Date: Tue, 17 Dec 2002 12:12
Date: Tue, 17 Dec 2002 12:12
24 lines
1938 bytes
1938 bytes
> 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
Technical Details
Message-ID:
<3dff15d6@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-01!sn-xit-09!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!news.webusenet.com!newsfeed.news2me.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<3dfecc40@newsgroups.borland.com> <3dfee4ba@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-17 04:36:09 PST From: "Dmitry" <programmer@mail.spbnit.ru> Newsgroups: borland.public.cppbuilder.database.ado References: <3dfecc40@newsgroups.borland.com> <3dfee4ba@newsgroups.borland.com> Subject: Re: How to use parameters in TADOQuery Date: Tue, 17 Dec 2002 15:12:00 +0300 Lines: 36 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.243 Message-ID: <3dff15d6@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1040127446 212.48.199.243 (17 Dec 2002 04:17:26 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-01!sn-xit-09!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!news.webusenet.com!newsfeed.news2me.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail