Article View: borland.public.cppbuilder.database.ado
Article #1905Re: Using a parameter multiple times
From: Freshy
Date: Fri, 16 Jan 2004 06:22
Date: Fri, 16 Jan 2004 06:22
30 lines
2231 bytes
2231 bytes
Thank you again for the reply, however, this will not work either. Part of the specification for the program is that it have a built in report designer so that users may create reports on the fly. Any one who has ever done this knows that parameterized queries become a problem. I am using QRDesign and have code in place which inspects the parameter names. Depending on the configuration, it will then create a dynamic form to fill in those parameters. If I give the the parameters different names, the user will then be prompted for the same information twice. There will just be one form, but the start and end dates will be on there twice. The last option I have, and one that I have been resisting, is to have code that instead of creating a control on the form, just creates an alias for control created by the "first" parameter. This seems messy however, and I was hoping that I could find a solution through SQL. Thanks Again, Ken "Arnie Mauer" <xxx@nowhere.net> wrote in message news:4006f0cc$1@newsgroups.borland.com... > Rename your parameters so that they have unique names. For example, you'll > have to seperately set :SDate1 and :SDate2. > > The BDE handled this case but ADO doesn't. > > - Arnie > >
Technical Details
Message-ID:
<4007833e$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!news-hog.berkeley.edu!ucberkeley!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<40034ae2$1@newsgroups.borland.com> <4006f0cc$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,1641a77b6273a1af X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2004-01-15 22:38:46 PST From: "Freshy" <_REMOVE_THIS_freshy_s@hotmail.com> Newsgroups: borland.public.cppbuilder.database.ado References: <40034ae2$1@newsgroups.borland.com> <4006f0cc$1@newsgroups.borland.com> Subject: Re: Using a parameter multiple times Date: Fri, 16 Jan 2004 00:22:53 -0600 Lines: 32 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 NNTP-Posting-Host: 65.123.110.23 Message-ID: <4007833e$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1074234174 65.123.110.23 (15 Jan 2004 22:22:54 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!news-hog.berkeley.edu!ucberkeley!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail