Passing parameters in a query

  • Thread starter Thread starter Ivan Debono
  • Start date Start date
I

Ivan Debono

Hi all,

I've got a union query that requires 2 parameters. I'm using vb6 to make a
select statement based on this query but i don't know how to pass the
parameters automatically so no parameter dialog pops up.

Is it possible to pass parameter values automatically with the query?

Thanks
Ivan
 
Try creating the Select SQL String from scratch with the parameters resolved
to explicit values in the SQL String so that your SQL String is not
parametrised.
 
Problem solved. I left the parameters inside. In VB, I just created an ADO
command object and set the parameter values accordinly. Works like a charm!!

Ivan
 
Back
Top