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