🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Using a parameter multiple times

#1905
From: Freshy
Date: Fri, 16 Jan 2004 06:22
30 lines
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-mail
References: <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