Passing parameters in a query

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
 
V

Van T. Dinh

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

Ivan Debono

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
 
Top