Could you do a row (COUNT(*)) into variables immediately before and after the insertion, and do a subtraction between them?
Bruce On Jun 7, 2021, 06:41 -0700, Doug Hamilton <[email protected]>, wrote: > Is there a way to get the number of rows inserted into a table without > displaying the FEEDBACK dialog? > > I need to know the number of rows inserted into a table, values could range > from 1 to a couple of hundred rows. > SET FEED BACK ON produces a system variable of rows inserted that I capture > with: > SET VAR vRBTI_RowsInserted = .RBTI_RowsInserted > > But that displays a Feedback dialog message that I clear with CLS - the quick > flash of the Feedback message is disconcerting/irksome to users. > > From the online help: > "To display the FEEDBACK results from the last INSERT, UPDATE, or DELETE, > without displaying the FEEDBACK dialog, initiate the following PROPERTY > command parameter: PROPERTY APPLICATION GET_LAST_FEEDBACK ' ' > > I did that before the INSERT command but the FEEDBACK dialog still displayed. > > What's the obvious that I'm missing? > > TIA, > Doug > RBG X5E, update 20513 > > > This email has been checked for viruses by Avast antivirus software. > www.avast.com > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/9a68f7ba-f969-57ba-1c65-982123f62cce%40wi.rr.com. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/cfe5acb0-c758-4e62-a6c3-78638d218a7d%40Spark.
