Hi,

> How do I use the new ROW_COUNT context variable in FB2?
> F.e. select row_count from rdb$database gives me:
> ---------------------------
> Dynamic SQL Error
> SQL error code = -104
> Token unknown
> ROW_COUNT on line 1 : select row_count from rdb$database
> ---------------------------

ROW_COUNT is only used in PSQL (Stored Procedures and
Triggers) after any DML operation.

eg:

INSERT INTO ...

ChangedRows = ROW_COUNT;



In Firebird 2, ROW_COUNT can also return the number of
rows selected after doing a SELECT (eg: cursor open) in
PSQL.

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com