Translating System Messages

USoft applies USoft-defined system messages as default texts in default applications. System Message records for these messages are automatically created for you (in table T_SYS_MSG) when you (re)run the Load System Messages routine from the Tools, Language submenu in USoft Definer. Here is an example of such a record, along with its (2) Parameter child records. This example record has a USoft-defined Category:

This record has the following child records:

You can add System Messages that you define yourself. Do this simply by adding (INSERT) new System Message records manually. Make sure you use a Category that you have defined yourself and an integer value for Code that is unique within that Category. You can call user-defined messages by invoking the MessageLanguage method of the RulesEngine internal component. For example:

INVOKE   RulesEngine.MessageLanguage WITH

SELECT   'My Message Category'

,        'MY_MESSAGE_NAME'

,        'ERROR'

,        'Source file "' || p.source_file ||

         '" does not exist.'

FROM     p_apply_custom_xsl p

WHERE 0 =

(

    INVOKE     uswtw_winfiles.filesexist WITH

    SELECT     p.source_file

)

To translate a message text stored in a System Message record, for each Language you want to translate the message into, create (INSERT) a System Local Message record (in table T_SYS_MSG_LNG).

This way, you can translate System Messages that USoft uses in the default application, but also System Messages that you have added yourself.

Make sure that each System Local Message is correctly related to the System Message record that it translates. Do this by making sure that the combination ( Code, Category ) is the same in both records. Here is the translation of the example message from the previous section: