Parameter query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I create a parameter query that allows me to pass the criteria via
ODBC? I am going to execute this query via an ODBC procedure call, and I
want to pass the value with this call to the query. I do not know how to
properly create the query so it recognizes the parameters passed via the
procedure call.
 
Barry said:
How do I create a parameter query that allows me to pass the criteria via
ODBC? I am going to execute this query via an ODBC procedure call, and I
want to pass the value with this call to the query. I do not know how to
properly create the query so it recognizes the parameters passed via the
procedure call.

Ways to do this are DAO & SQL Pass Through (SPT) query or ADO & using
the Command object's Parameters. Which do you want to do?
 
Back
Top