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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only