Hello : How to using parameters with VFP and SQLCE 3.5, ?


CadCon="Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data Source=C:\Employes.SDF;SSCE:Database Password='';"
oc = CREATEOBJECT('adodb.connection')
oc.open(CadCon)

* Create Command
oComm=CREATEOBJECT("ADODB.COMMAND")
oComm.activeConnection=oc

* Select all records (ok)
cSQL="Select * from Employes"
mytabla=oc.execute(cSql)

*Now how to select selective records using Variables, because the following code is not working
cSQL="SELECT FROM EMPLOYE WHERE NAME = ? VP_NAME
myTabla=oc.execute(cSql)

Thanks very much!