You may already know about this, but one thing to careful about with @@ROWCOUNT in SQL Server is that it may be reset after each T-SQL statement, like @@ERROR is. Just to be careful, after I execute a SELECT, INSERT, whatever, I:

SELECT @ErrorNo = @@ERROR, @RowCnt = @@ROWCOUNT

Then at the end of the sproc, I use @RowCnt rather than @@ROWCOUNT

>Hi,
>
>I had some problems with your second option, using @RowCnt integer OUTPUT
>ect.
>
>I'm able to get the row count into vfp by adding "select @@rowcount" at the end of the stored procedure and the result shows up in athe vfp cursor sqlresult.
>
>Thanks again for your suggestions.
>
>Paul
>
>>If you are creating a record set in your stored procedure, the record set will be in SqlResult, provided the SQLEXEC returns 1, so you need to makes sure y = 1 in the above statement.
>>
>>If successful, you can check the @@ROWCOUNT in VFP indirectly with:
>>
>>RECCOUNT( "SqlResult" )
>>
>>You can also pass back @@ROWCOUNT via an OUTPUT parameter in your stored procedure:
>>
>>CREATE SPROC sp_Calculate
>>@RowCnt integer OUTPUT
>>AS
>> SELECT * FROM TableName
>>
>> @RowCnt = @@ROWCOUNT
>>
>>RETURN 0
>>
>>Then your SQLEXEC becomes:
>>
>>LOCAL lnRowCount
>>
>>lnRowCount = 0
>>
>>IF SQLEXEC(1,'sp_calculate ?@lnRowCount') = 1
>>
>>ENDIF