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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement