When we execute an INSERT/UPDATE/DELETE against an RBase table, those
messages or feedback (when set ON) tell us how many rows were acted
upon.

Is there a means to capture that number immediately upon completion of
the statement, such as some sort of System Variable?

I know I could do a :

   SELECT COUNT(*) INTO vMyCount ... WHERE ... 

Using the same WHERE-clause as in the intended operation.  But it would
be cool to be able to "snag" that little ol' number and store it in a
table to keep up with certain metrics related to DB-administration.


Thanks,
Steve in Memphis



J. Stephen Wills
Program Manager, Research Informatics
Office of the Vice Chancellor for Research
University of Tennessee Health Science Center
62 S. Dunlap, Suite 400
Memphis, TN  38163
Office: 901-448-2389
FAX    : 901-448-7133


Reply via email to