Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Different ways to connect to SQL server
Message
 
À
16/02/2004 12:10:01
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00877675
Message ID:
00877714
Vues:
20
I was able to connect to my data source and execute a simple select statment. However, what is the syntax to call a stored procedure. What I used to use was:

hConn=SQLConnect("pbisqlmemsales")
lcsql="exec sp_ndcusage_xml ?memno,?ndcnum,?sdate,?edate"
lnresult=SQLEXEC(hConn,lcsql,"testdata")

Using the vfpcomm utility I used the rstocusror() function to take the record set to a cursor but how would I execute the stored procedure with the paramters?

Thanks again
Kelly
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform