When we want to insert, modify or delete a record within our form it can not be possible because of the database errors that are previously configured, which can be generated by ourselves by means of triggers, for example:
In this example we create a trigger for each time you want to unsubscribe or delete a record from a specified table.
How can this error be already configured by default:
[Microsoft][Controlador ODBC SQL Server] [SQL Server] You can not delete the record
Then, to capture those types of errors, we have a macro called sc_error_continue, whose function is to capture the errors that are generated from the database.
An example would be when wanting to delete, then there is a ScriptCase variable that contains the message error extracted from the database, whose variable is called sc_error_delete which has the following message in it: You can not delete this record.
Then we find an example of how the macro can be used:
You can also find the information within the manual: Click Here