Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Passing variable to SQL stored procedure
Message
De
06/10/2005 14:19:51
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Passing variable to SQL stored procedure
Divers
Thread ID:
01056877
Message ID:
01056877
Vues:
52
There is a call to SQL stored procedure from VFP:
lcDrv_CD = "1001"
loRS = oData.oConn.Execute("usp_dsp_TooLate2AddInvoice '" + lcDrv_CD + "'")
?loRS.Fields(0).Value 
Is there a way to pass variable directly? Something like:
loRS = oData.oConn.Execute("usp_dsp_TooLate2AddInvoice ?lcDrv_CD")
or similar?

I've tried several ways but could not find correct one.

Thanks.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform