Thanks Chris,
I'll give this a try and let you know how it went.
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
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