How To Retrieve the Strings/Messages Which Have No Translation

Previous Next

To retrieve the application strings which do not have a corresponding translation yet:

1. From the menu bar, choose Tools, SQL Command.

The SQL Command window appears.

2. Type the following code in the SQL Statement field:

SELECT * FROM T_APP_USED_STR U

WHERE NOT EXISTS

(SELECT '' FROM T_APP_LNG_STR L

WHERE L.STR_CODE = U.STR_CODE)

3. Click Create and the Used Application String window will be displayed.
4. Click F2 to define a query and F3 to execute the query.

The Strings that do not have translation will be retrieved. Open the related window for the translation and translate the application strings.

To retrieve the system messages which do not yet have corresponding translation:

ยท Follow the same steps as described above, but use the following SQL statement:

SELECT * FROM T_SYS_MSG S

WHERE NOT EXISTS

(SELECT '' FROM T_SYS_MSG_LNG L

WHERE L.MSG_CODE = S.MSG_CODE)