Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to use parameters with SQL CE ?
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
How to use parameters with SQL CE ?
Divers
Thread ID:
01524665
Message ID:
01524665
Vues:
105
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!
- On the Road
In circle of Life
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform