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
>