CURSORTOXML() function is not listed as supported in stored procedures(SP). Try to get this SP to work from VFP first.

>I tried the following code and it will not work?
>It gives me the error message:
>'Feature is not available.
>/foxtest2.asp, line 7'
>
>Here is my ASP Code:
>set goConn = server.CREATEOBJECT('ADODB.Connection')
>lcSQLCMD = 'AddValues()'
>goConn.OPEN('Provider=vfpoledb;Data Source=' + 'f:\apps\pbx\pbx.dbc')
>set goRS = goConn.Execute(lcSQLCMD)
>response.write goRS.FIELDS(0).VALUE
>
>And here is my Foxpro Stored Procedure Code:
>PROCEDURE AddValues()
>sELECT * from calls2 WHERE RECNO()<5 INTO CURSOR mycursor
>CURSORTOXML('mycursor','myoutput',1,0)
>RETURN myoutput
>ENDPROC
>
>I started with the example give by Microsoft that added two numbers. It worked fine. But when I tried to create a cursor and return the values it gave the the error.
>
>I have also tried a very simular program using soap and web services. The web services works fine until I try to run a query.
>
>I don't understand why someone would want to create a stored procedure and call it, if the procedure was not accessing any data. I can do my own calulations in ASP.
>
>Anyone have any suggestions?