Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Different ways to connect to SQL server
Message
 
To
16/02/2004 12:10:01
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00877675
Message ID:
00877714
Views:
19
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform