Remove transactionid from the insert. I assume it is an autonumber? Dan Goldberg
-----Original Message----- From: [email protected] <[email protected]> On Behalf Of Doug Hamilton Sent: Wednesday, July 17, 2019 4:16 PM To: R:Base List <[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/8ea2193f-8f69-1f62-130d-a932c6ad6809%40wi.rr.com. For more options, visit https://groups.google.com/d/optout. -- 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/2E4830CEC16615458329D3D83342F8D0011EA9C004%40EXCHANGE10. For more options, visit https://groups.google.com/d/optout.
