Creating a Message Table

You create a message table which stores error message information.

  1. 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

  2. Generate the table in your database.
  3. Select Database > Execute SQL.

    A dialog box asks you to identify a data source and connection parameters.

  4. Select a data source and fill in connection parameters.
  5. Click Connect.

    An SQL query editor box is displayed.

  6. Type an SQL statement to insert a message number and text in the appropriate columns. You can use the following format 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')

  7. Click Execute.

    A message box tells you that the command has been successfully executed.

  8. Click OK.

    You return to the SQL query box.

  9. Click Close.