Hello All,

I'm converting a VFP app into VB, and in my code I have two variables, lccompany and lcproperty, that I need to set as parameters in a SQL statement. The VFP query would look something like this:

select code ;
from c_qcldinco ;
where company == lccompany and property == lcproperty and type = "R" ;
into cursor c_rentcode

I believe that I need to use a ADODB.Command object on the ADODB.Connection variable that I've already instantiated on the Access Database.

Can anyone give me or refer me to some example code which would use the values of these variables as parameters in an ADO SQL statement?

Thanks,

Ben Holton

Conarc, Inc.