You create a message table which stores error message information.
Column to store...
Description
Error number
Number of the error message that is referenced in the trigger script
Message text
Text of message
A dialog box asks you to identify a data source and connection parameters.
An SQL query editor box is displayed.
insert into table values (error number,'error message')
insert into ERR_MSG values (1004,'The value that you are trying to insert does not exist in the referenced table')
A message box tells you that the command has been successfully executed.
You return to the SQL query box.