Sub query using parameters with OleDb Data adapter problem

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

Guest

I am trying to display the results in a form from a complex query that uses parameters. Both the outside and the inside query use parameters. I can get the outside query to run but when I use a subquery with parameters for a condition in the main query I keep getting DB_E_BADORDINAL error

Any help or suggestions are greatly appreciated

Jea
 
You haven't posted any schema, code or query syntax, so it's
impossible to make specific recommendations. However, if you write
your query as a parameterized stored procedure you can simplify the
debugging process considerably.

--Mary
 

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

Sub query using parameters with OleDb Data adapter problem 2
Creating an update query that uses multiple parameters 2
Access Invalid bracketing of parameter name 1
Create a parameter for the oledb data adapter 1
Query Parameter using multiple options 0
SQL Server 2005 throught OLEDB : Named parameter problem ? 3
Type is invalid error 3
Parameter Value error in a Subform 0

Back
Top