Parameters come up twice


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Parameters come up twice

  1. #1
    Gill Guest

    Parameters come up twice


    Hi everyone,
    This has happened me in loads of different databases.
    I have a parameter query but the query prompts for the criteria more than
    once, usually twice but I have one query now that asks the user to enter
    in the criteria three times.
    A typical query would be a date dependant query where the user would be given
    the following query:
    "Select * from Deliveries where DeliveryDate Between [Enter Start Delivery
    Date] and [Enter Last Delivery Date];

    Does anyone know why this happens, and does anyone know how to fix it??????
    Thanks
    Gill


  2. #2
    Paul Clement Guest

    Re: Parameters come up twice

    On 18 Dec 2000 06:44:23 -0800, "Gill" <GMaloney@PBS.ie> wrote:


    Hi everyone,
    This has happened me in loads of different databases.
    I have a parameter query but the query prompts for the criteria more than
    once, usually twice but I have one query now that asks the user to enter
    in the criteria three times.
    A typical query would be a date dependant query where the user would be given
    the following query:
    "Select * from Deliveries where DeliveryDate Between [Enter Start Delivery
    Date] and [Enter Last Delivery Date];

    Does anyone know why this happens, and does anyone know how to fix it??????

    It happens when the query processor is unable to identify field names in your query as belonging to
    a particular table. Make certain to check the spelling of the field names to ensure that they are
    correct.


    Paul ~~~ pclement@ameritech.net
    Microsoft MVP (Visual Basic)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center