ROW_COUNT

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Vlad Orlovsky
Sent: Friday, July 28, 2006 1:40 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] @@rowcount equivalent after executing a SP

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


++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links