If you're driving this from a form there is the GETPROPERTY TABLE 'Customer->RECORDCOUNT' vRecordCount. I use it when we import a large csv file each morning and I want to know how many reads are imported.
A bit button on the form fires the import command A variable placed on the form then displays the record count in the import table on the form GETPROPERTY TABLE 'Pondreads->RECORDCOUNT' vcnt It's very instantaneous and just another way to count rows in a table during processing.. Just another option to think about. On Tue, Jun 8, 2021 at 5:40 AM Doug Hamilton <[email protected]> wrote: > Thanks Mike - that's the answer to Bruce's post earlier using SYS tables. > It works for additions or deletions and is more elegant than counting rows > because it is independent of any column, it's values, or nulls...and > probably a few micro-seconds faster. > > Do you know if there's an equivalent for updates? > Doug > > On 6/7/2021 1:35 PM, [email protected] wrote: > > 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 > <https://groups.google.com/d/msgid/rbase-l/fd4ee3ed-a9af-432b-8c0a-ec1c20c1c9a4n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > > > > ------------------------------ > [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> > > > <#m_6864082279387956337_m_7984716739311557633_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> > > -- > 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/f6ca6acc-e2af-b25c-0b3d-617d59b59e42%40wi.rr.com > <https://groups.google.com/d/msgid/rbase-l/f6ca6acc-e2af-b25c-0b3d-617d59b59e42%40wi.rr.com?utm_medium=email&utm_source=footer> > . > -- Regards Tony -- 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/CABnhDAS0Yw8%2BgepMx4NDU6s6JoFH4qPLHXioiyQstt05%2BvLQsg%40mail.gmail.com.
