Article View: borland.public.cppbuilder.database.ado
Article #3062Re: How to use parameters in TADOQuery
From: Victor Cazacov
Date: Wed, 08 Jan 2003 11:16
Date: Wed, 08 Jan 2003 11:16
17 lines
1633 bytes
1633 bytes
������, Dmitry ! D> My problem is that, if i use in the query parameters with the same D> name twice, the VCL apply only first one and don't use the other. D> For example: D> SELECT * FROM detail_table WHERE address_id =:id AND something else D> is equal =:id Why do not write simply: SELECT * FROM detail_table WHERE address_id =:id AND something else is equal = address_id ? -- Regards, Victor
Technical Details
Message-ID:
<3e1c08c3@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!fu-berlin.de!news.boerde.de!nntp.cs.uni-magdeburg.de!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mailReferences:
<3dfecc40@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 10698b,d6b087b7370736cc X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2003-01-08 03:31:29 PST Reply-To: "Victor Cazacov" <victor@kazakov.net> From: "Victor Cazacov" <victor@kazakov.net> Newsgroups: borland.public.cppbuilder.database.ado References: <3dfecc40@newsgroups.borland.com> Subject: Re: How to use parameters in TADOQuery Date: Wed, 8 Jan 2003 12:16:22 +0100 Lines: 19 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Comment-To: Dmitry FL-Build: Fidolook Express 2001 UIExt. BuildID: 3BC00FAD (7/10/2001 10:17:49). NNTP-Posting-Host: 195.143.24.227 Message-ID: <3e1c08c3@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1042024643 195.143.24.227 (8 Jan 2003 03:17:23 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!fu-berlin.de!news.boerde.de!nntp.cs.uni-magdeburg.de!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mail