Error Handling (Magic xpa 4.x)

What do we mean by an error? My programs do not have errors!

There is a well known proverb that says “To err is human”. But we all know that to totally foul things up takes a computer. But here we are not referring to programmatic errors per se. Here we are referring to database errors. These errors are generally as a result of an attempt to perform something that goes against the database constraints. What do we mean by this? Well remember we spoke about referential integrity? We had the accounts table that had a transaction history table. If we were to try and delete a record from the accounts table and there were still records for that account in the history table, the RDBMS would stop us: “Hey, you can’t do that”. We would have to first delete the records from the history table and only then would we be able to delete the record from the accounts table.

In this section, you can find information about the following:

Error Handling – The Concept

Magic xpa Behavior

Error Functions