Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Passing variable to SQL stored procedure
Message
From
06/10/2005 14:19:51
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Passing variable to SQL stored procedure
Miscellaneous
Thread ID:
01056877
Message ID:
01056877
Views:
51
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.
Next
Reply
Map
View

Click here to load this message in the networking platform