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
---
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/3caad3f0-eb48-7248-f4dd-244083946c33%40wi.rr.com.
For more options, visit https://groups.google.com/d/optout.
