2 Parameters with the same Name

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

Date: Fri, 9 Jul 2004 17:58:34 +0200

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

Relevant Pages

  • Re: I use the same parameter in 2 queries - how do I only enter once?
    ... Enter it in a control of a form? ... Then, use the syntax FORMS!formNameHere!ControlNameHere ... for each query. ... need to supply the parameter twice. ...
    (microsoft.public.access.queries)
  • Multiple references to the same named parameter fails?
    ... I have a query that references the same named ... parameter twice, like this (meaningless) query: ... How am I supposed to use the same variable twice? ...
    (microsoft.public.sqlserver.ce)
  • RE: Parameter query question
    ... I get the enter parameter twice when I click directly on the query and ... "Duane Hookom" wrote: ... Do you get the enter parameter twice when directly opening the query or when ...
    (microsoft.public.access.queries)
  • RE: Parameter query question
    ... Do you get the enter parameter twice when directly opening the query or when ... Try copy and paste the SQL into a new blank query and see if you get ... prompted twice. ... "Duane Hookom" wrote: ...
    (microsoft.public.access.queries)
  • Re: 2 Parameters with the same Name
    ... > Good luck, ... >> is there a way to use the same Parameter twice in a TADOQuery without ... >> Thank you, Christof ...
    (borland.public.delphi.database.ado)