>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
Local oConn as 'Adodb.connection', lcDataPath
lcDataPath = "c:\MyPath\MyData.dbc"
oConn = CreateObject('Adodb.connection')
oConn.ConnectionString = "Provider=VFPOLEDB.1;Data Source="+m.lcDataPath
oConn.Open
oRs = oConn.Execute("MyStoredProc(parm1,parm2,...)")
? oRs.Fields(0).Value
Cetin