set var vBegRowCount integer = null set var vEndRowCount integer = null Select sys_num_rows into vBegRowCount from sys_tables where sys_table_name = 'someTable'
-- do your insert or delete here Select sys_num_rows into vEndRowCount from sys_tables where sys_table_name = 'someTable' -- Do your math here (Rbase keeps track of the table row count for free!) On Monday, June 7, 2021 at 10:51:58 AM UTC-4 Doug Hamilton wrote: > Thanks Bruce & Karen - The rows to be inserted are a compound SELECT on a > table with ~350,000 rows (and growing) going into a new temp table > that....whoopsie. > SET RED FACE OFF > (the answer is too embarrassingly simple to post) > Doug (um, I was asking for a friend :) > > 'Course, it would still be nice to have something like SET FEEDBACK SILENT > that would give feedback insert/delete/update results without the dialog > box and eliminate a couple of SELECTS and additional code. > > > On 6/7/2021 9:01 AM, 'Karen Tellef' via RBASE-L wrote: > > 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? > > 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 > > > ------------------------------ > [image: Avast logo] <https://www.avast.com/antivirus> > This email has been checked for viruses by Avast antivirus software. > www.avast.com <https://www.avast.com/antivirus> > > -- > 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 > > <https://groups.google.com/d/msgid/rbase-l/9a68f7ba-f969-57ba-1c65-982123f62cce%40wi.rr.com?utm_medium=email&utm_source=footer> > . > > -- > 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 > > <https://groups.google.com/d/msgid/rbase-l/cfe5acb0-c758-4e62-a6c3-78638d218a7d%40Spark?utm_medium=email&utm_source=footer> > . > -- > 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 > > <https://groups.google.com/d/msgid/rbase-l/87414739.86656.1623074465564%40mail.yahoo.com?utm_medium=email&utm_source=footer> > . > > > -- 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/fd4ee3ed-a9af-432b-8c0a-ec1c20c1c9a4n%40googlegroups.com.
