You can use the ROW_COUNT variable.

UPDATE ...;
result = ROW_COUNT;

On 7/28/06, Vlad Orlovsky <vmo3d@...> wrote:
>
> Hi Everyone,
>
> Do you know what is the SQL Server @@rowcount
> equivalent in Firebird.
>
> I'd like to know the number of rows affected from my
> .NET application after command.ExecuteNonQuery()
> statement.
>
> SQL Server Example:
>
> UPDATE TABLE1
> SET .....
>
> RETURN @@ROWCOUNT; --Returns number of rows affected
> by the previous SQL statement.
>
> Thanks in advance,
> Vlad
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
>


[Non-text portions of this message have been removed]