You can create a message table in your database to store user-defined error messages. When you select trigger generation parameters, you can choose to generate an error message from this table.
Create a table with columns to store the following information:
Column to store...
Description
Error number
Number of the error message that is referenced in the trigger script
Message text
Text of message
Generate the table in your database.
Select Database > Execute SQL.
Select a data source, fill in connection parameters, and click Connect.
An SQL query editor box is displayed.
Enter an SQL statement to insert a message number and text in the appropriate columns. For example:
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')
Click Execute.
A message box tells you that the command has been successfully executed.