Problem on Query statement


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Problem on Query statement

  1. #1
    Fiona Guest

    Problem on Query statement


    For a parameter query statement

    if there is only one parameter in the query statment is :
    PARAMETERS [param1] variable type; SELECT * FROM table where field

    what if I need more than one parameters how can put the additional parameter
    in the PARAMETERS part?



  2. #2
    Arthur Wood Guest

    Re: Problem on Query statement


    Fiona,
    Simply use the format like this:

    PARAMETERS [param1] Type,[param2] Type, [param3] Type;

    Arthur Wood

    "Fiona" <fionalee@home.com> wrote:
    >
    >For a parameter query statement
    >
    >if there is only one parameter in the query statment is :
    >PARAMETERS [param1] variable type; SELECT * FROM table where field
    >
    >what if I need more than one parameters how can put the additional parameter
    >in the PARAMETERS part?
    >
    >



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