You're welcome.

>Thanks very much Sergey.
>
>>First, the SQLEXEC() returns -1 in case of failure, not 0.
>>
>>There're three ways to return value(s) from stored procedure:
>>1. The RETURN statement. Only one integer value can be returned and it ususally used to indicate success(0) or error code (non 0).
>>2. The OUTPUT parameter(s). Can be of ony type allowed for stored procedure parameters
>>3. The Record set.
>>For example,

* VFP
>>lnRetval = 0
>>lcStr = ""
>>lnResult = SQLEXEC(lnConn ,[{?@lnRetval=CALL Proc_test(1,2, ?@lcStr)}], "crsTemp" )
>>IF lnResult < 0
>>  * Use AERROR() function to get ODBC error info
>>  * Process error
>>ENDIF
>>
>>? lnRetval, lcStr, crsTemp.col1, crsTemp.col2
>>--------------------------------------------------------------------
>>-- SQL Server
>>if exists (select * from dbo.sysobjects
>>	where id = object_id(N'[dbo].[proc_test]') )
>>drop procedure [dbo].[proc_test]
>>GO
>>CREATE PROCEDURE proc_test
>>	@p1 int,
>>	@p2 int,
>>	@c3 varchar(36) OUTPUT
>>AS
>>        -- Output parameter
>>	SET @c3 = CAST(getdate() AS varchar(36))
>>        -- Recordset
>>	SELECT 'proc_test completed' AS col1, getdate() AS col2
>>-- Return value
>>RETURN 123
>>GO
>>

>>
>>
>>
>>>Hi all!
>>>
>>>Is it possible to return values from a stored procedure?
>>>
>>>I'm connection to the SQL-Server either by VFP (7, 8) and VB.NET.
>>>AFAIK the VFP SqlExecute() returns only 0 in case of failure and 1 in case of success.
>>>
>>>Thanks for advice.