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?
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