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.
Procedure
- 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 .
- 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.
- Click OK to return to the SQL query dialog.
- Click Close.