OnError (Continue)

Used as a scoping keyword, similar to WorkWith/End WorkWith.


"Error Message Text"

Set the OnError state to one of the following options:





It is important to note that Database Record related commands (New, Updated, Delete, Attach, Detach, etc...) will only result in a runtime error if there is a problem with the overall command, not an individual Record. To test for individual Record errors, the Error Field within the Query (which is created automatically if/when an error occurs) must be tested instead. A useful tool for this task is the [CountIf] TopQuery command, where an example is provided.