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
------------------------------------------------------------------------
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
<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
<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
<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
<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]
<mailto:[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>.
--
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.
