See
Re: Can stored procedures return values? Message #
876903.
>I have a Stored Procedure in my DB SQL Server
>CREATE PROCEDURE Sp_Teste
> @Text as nvarchar(20)
>WITH ENCRYPTION
>AS
>
>If @Text = ''
> RETURN(1)
>....
>....
>....
>GO
>
>I call this SP in VFP
>
>nError=SQLEXEC(nHandleConnection, "exec Sp_Teste")
>
>How can i obtain the Return Value of Stored Procedure in my code VFP
>
--sb--