See
Re: Can stored procedures return values? Message #
876903>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
--sb--