I often do what Bruce suggests if I want to insure that all the rows got inserted as expected Karen -----Original Message----- From: Bruce Chitiea <[email protected]> To: [email protected] Sent: Mon, Jun 7, 2021 8:56 am Subject: Re: [RBASE-L] - Rows Inserted feedback
Could you do a row (COUNT(*)) into variables immediately before and after the insertion, and do a subtraction between them? BruceOn 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. -- 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/87414739.86656.1623074465564%40mail.yahoo.com.
