Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
OLEDB, and Stored Procedures?
Message
De
18/09/2001 11:16:11
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00557607
Message ID:
00557870
Vues:
7
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
Fil
Voir

Click here to load this message in the networking platform