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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only