Message Type

Select from this list the type of message the object is:

• 5: Standard Message or Text: Use this for all messages that are not a constraint or a delete constraint message. 

  Messages of this type are retrieved and/or formatted in SQL database code. These include the substitution of specified text for the &1, &2, (and so on) expressions. They operate using the MsgAppSp or MsgAskSp stored procedures or by means of a method in IDO extension class code that runs in the IDO Request layer.

• 17: Constraint Message: Use this type to report SQL constraint violations, such as foreign key, check constraint, and so on. The message name must match the SQL constraint name.
• 18: Delete Constraint Message: Use this for foreign key constraint messages that are specific to reporting that an object cannot be deleted because it is referenced as a foreign key from another table.

  The message name must match the SQL constraint name.

  Note: Two messages can be created against the same Foreign Key constraint name, if needed—one of type 17 and one of type 18.