Parameter query

B

Barry

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.
 
M

MGFoster

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.
Click to expand...

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Query help - Not passing parameter? 3
parameter passthrough query 1
ODBC Pass-through query with parameter from table 5
Pass-Through Query Error 1
Access pass-through query to Oracle 10g stored procedure - results 1
Like "* " and function to pass parameters into a query 4
help using a parameter in an 'In (...)' criteria 6
ODBC Pass-Through Queries 2

Top