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]
<mailto:[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]
<mailto:[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]
<mailto:[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>.
--
This email has been checked for viruses by Avast antivirus software.
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/258e97dc-774f-8f40-e160-6e1801de9103%40wi.rr.com.
