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?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement