Message Type

Specify the message type:

• 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, including the substitution of specified text for the &1, &2, etc., expressions, via the MsgAppSp or MsgAskSp stored procedures or via a method in IDO extension class code that runs in the IDO Request layer.
• 17: Constraint Message. Use this to report SQL constraint violations such as foreign key, check constraint, etc. 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 references 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.