Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi there,
What I was trying to do was use a stored procedure. I've used a straight recordset object and that's working fine, but eventually I'm gonna need to get these stored procedures working. At the moment I'm working over a LAN and the speed isn't so much of a problem but my client software will eventually work over a WAN using TCP/IP to connect. When that's up and running I'm gonna need those stored procedures.
The code is :
local loCM, loRST
loCM = createobject("adodb.command")
loCM.ActiveConnection = goCn
loCM.CommandText = "{? = call MCC.CLINIC.GetExpenseCursor}"
loCM.CommandType = gnCmdStoredProc
loRST = loCM.execute
The error message that is returned is 'CLINIC.GetExpenseCursor is undefined'. I do have the priviledges to run this procedure.
Thanks for your input.
Pablo
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