Versions des environnements
Network:
Windows 2003 Server
There is a stored procedure as simple as this:
CREATE PROCEDURE sp_test AS
RETURN 33
GO
I'm trying to get the return value from VFP using ADO:
LOCAL loConn AS ADODB.Connection, lvRetVal
CLEAR
loConn = CREATEOBJECT("ADODB.Connection")
loConn.ConnectionString = GetConnString()
loConn.Open()
* 1 - Execute
lvRetVal = loConn.Execute("sp_Test")
?VARTYPE(lvRetVal), lvRetVal &&Shows O (Object)
* 2 - as a native method
lvRetVal = loConn.sp_Test() &&Crashes
?VARTYPE(lvRetVal), lvRetVal
loConn.Close()
First call returns an object and as I can see from debugger it's a recordset. How would I get the number SP actually returns?
Second call is supposed to be working according to Microsoft. I'm getting an error:
"OLE IDispatch exception code 0 from ADODB.Connection: Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another..."
But there is no arguments. What does it want from me?
Thanks
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