General information
Category:
Database DAO/RDO/ODBC/ADO
Title:
SQL Statement With Parameters
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only