Re: 2 Parameters with the same Name

From: Christof Schädeli (ch.schaedeli_at_gmx.ch)
Date: 07/12/04 

Date: Mon, 12 Jul 2004 11:23:34 +0200

Hi Kevin,
thanks for you answer, that's exactly what I needed.
Christof

"Kevin Frevert" <Work@drinkingcoffee.com> schrieb im Newsbeitrag
news:40eef89f@newsgroups.borland.com...
> Christof,
> In the TADODataSet.CommandText (at design time)
>
> Declare
> @MyParam int
> SET @MyParam = :MyParam
>
> Select Field1, Field2
> From SomeTable
> Where
> (Field1 > @MyParam) AND (Field2 < @MyParam)
>
> Good luck,
> krf
>
> "Christof Schädeli" <ch.schaedeli@gmx.ch> wrote in message
> news:40eec0a8@newsgroups.borland.com...
> > Hi,
> >
> > I have a Query like this:
> >
> > SELECT * FROM TABLE
> > WHERE (Field1 > MyParam) AND (Field2 < MyParam)
> >
> > is there a way to use the same Parameter twice in a TADOQuery without
> > giving them different names like in TQuery, where only one
> Parameter-Object
> > is created for them?
> >
> > Thank you, Christof
> >
> >
>
>