I submitted this to RDCC. There is an error in the command syntax; they
have already corrected the online syntax!
The command file has an error in its syntax for the ON command:
ON AFTER ERROR ErrorPause.rmd
The syntax should be:
ON AFTER ERROR RUN ErrorPause.rmd
The "command" portion behaves as if you would type the line at the R>.
It is noticed the help file is missing the required "RUN" keyword from the
syntax, and will be updated.
We thank you for your feedback.
R:DCC Staff
Thanks to RDCC for the quick response!
Doug
On 7/18/2019 10:31 AM, Doug Hamilton wrote:
Dan - Karen is correct; all the columns are plain ol' text, I should
have mentioned that.
Karen - thanks for double-checking. I'm hoping to use the ON ERROR to
trap one of those phantom errors doesn't *appear* to have any
consistency. I don't want to bother the operator with the results of
SET ERROR MESSAGES ON in a portion of the code and having her write
down the err msg, so my plan is to discreetly log them to a table
without buggin' the operator (pun intended).
But I am unable to debug the debugging routine :)
Doug
On 7/18/2019 9:28 AM, 'Karen Tellef' via RBASE-L wrote:
Dan: he is purposely generating an error in order to test the "on
after error" command.
Doug: I had never used "on after error" before so I created 2
programs similar to yours and got the same result "illegal command"
rather than the pause error message. I tested with 10.5 enterprise.
I have no notes on how to use it and couldn't find anything in Help
Karen
-----Original Message-----
From: Dan Goldberg <[email protected]>
To: [email protected] <[email protected]>
Sent: Thu, Jul 18, 2019 8:37 am
Subject: RE: [RBASE-L] - On After Error error
Remove transactionid from the insert. I assume it is an autonumber?
Dan Goldberg
-----Original Message-----
From: [email protected] <mailto:[email protected]>
<[email protected] <mailto:[email protected]>> On
Behalf Of Doug Hamilton
Sent: Wednesday, July 17, 2019 4:16 PM
To: R:Base List <[email protected]
<mailto:[email protected]>>
Subject: [RBASE-L] - On After Error error
In an effort to generate more data than errors, I'm trying to use the
ON AFTER ERROR command but it errors out.
This is my simple test file with the obvious error of incorrect # of
columns in the INSERT:
SET MESSAGE On
SET ERROR MESSAGE On
ON AFTER ERROR LogError.RMD
INSERT INTO EINS (TransactionID,Item,URLNumber) +
VALUES ('EINS','TestItem')
ON AFTER ERROR RESET
RETURN
This is LogError.RMD
PAUSE 2 USING 'Error'
RETURN
I get the expected "Incorrect number of columns for this table" error
message but then I get "Illegal command in Entry/Exit Procedure."
I've tried all permutations of messages on/off, with and without "AFTER"
in ON ERROR.
Any clues for the blues?
TIA,
Doug
RB X.5E, 30704
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=icon>
Virus-free. www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=link>
<#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]
<mailto:[email protected]>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/3caad3f0-eb48-7248-f4dd-244083946c33%40wi.rr.com
<https://groups.google.com/d/msgid/rbase-l/3caad3f0-eb48-7248-f4dd-244083946c33%40wi.rr.com?utm_medium=email&utm_source=footer>.
For more options, visit https://groups.google.com/d/optout.
---
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/b43cb2dd-61f0-41a6-6d88-fd9b6cedcaaf%40wi.rr.com.
