Hi

I'm trying to return a value from an SQL procedure without much luck. My SQL procedure has the following code in it

CREATE Procedure Test
AS
return(-99)
GO

I'm using VFP to call this procedure:

=SQLExec(lnConnection, "execute myDatabase.dbo.Test", lnReturn)

Any ideas why this doesn't work?

Regards