Introduction › Text Strings › TEXT View › Text Strings Stored in the TEXT View

Text Strings Stored in the TEXT View

The TEXT view provides the only storage for text strings related to two views:

Join ID of TEXT with ID of the view for which the text was created.

For example, to select the name and message of an exit state, use this:

SELECT E.NAME, T.TEXT
FROM
MODEL M,
EXIT_STATE E,
TEXT T,
WHERE
M.NAME='my model name'
AND E.MODEL_ID=M.ID
AND T.ID=E.ID;

Note: To retrieve messages for non-default dialect exit states, join EXIT_STATE with EXIT_STATE_MESSAGE, MESSAGE and DIALECT_TEXT.