Subject | how can i use ROW_COUNT to get selected rows count ? |
---|---|
Author | emailkamlesh2000 |
Post date | 2005-04-15T13:34:09Z |
Dear Friends
i read following in FB 2 Release Notes
"Context variable ROW_COUNT returns select count"
"ROW_COUNT can now return the number of rows returned by a SELECT
statement. More information to come."
i get an error if i execute following
SELECT * FROM RDB$GET_CONTEXT('SYSTEM', 'ROW_COUNT');
How can i use ROW_COUNT to get selected rows count i.e. RecordCount
Thanks
Kamlesh
i read following in FB 2 Release Notes
"Context variable ROW_COUNT returns select count"
"ROW_COUNT can now return the number of rows returned by a SELECT
statement. More information to come."
i get an error if i execute following
SELECT * FROM RDB$GET_CONTEXT('SYSTEM', 'ROW_COUNT');
How can i use ROW_COUNT to get selected rows count i.e. RecordCount
Thanks
Kamlesh