Closed
How to find the number of record updated by RDB-Save.
Hi,
How can I get the no of record updated by rdb-save operation. I can see the number in DB-Trace but it does not seems to stored in any parameter. Can any one help me on this?
Thanks,
Saikat
Posted: 9 years ago
Pegasystems Inc.
IN
One way is:
Add a line above your SQL as the fitst line of your SQL as sbown below. You can name the page anything meaningful. This page will be viewed in the Clipboard that will have both pre and post SQL it executed.
{SQLpage:MySQLPage}
Posted: 9 years ago
Pegasystems
US
How about preceding your rdb-save with an rdb-query (or executeRDB api call) that does a "select count(*) . . .", using the SAME "where" clause on the "select count(*)" that you use on the subsequent rdb-save ? /Eric