Gary,
This shoud work for you.
lnRetval = 0
lnResult = SQLEXEC(nConnection,[{?@lnRetval=call MyProc}])
>Hi,
>Does anyone know how to get a return value from a SQL Server stored proc? For example, if I have a line of code "RETURN 123" in the proc, how do I receive that? The proc doesn't take an output parameter, just returns a number.
>
>? SQLEXEC(nConnection,[exec MyProc]) && Returns a 1 showing that the call didn't have an error
>
>Thanks.
>
--sb--