Multilingual Data

Visual LANSA Framework

Multilingual Data

In multilingual applications it may be necessary to have multilingual table data. In such situations it is common for a single code to have several descriptions, or sometimes, a different set of codes for different languages. The code tables system handles this by having one record for each language for each code.

Consider the table data for the VF_TITLE table

Title Code Language Title Description

MR

ENG

Mr.

MR

DEU

Herr.

MRS

ENG

Mrs.

MRS

DEU

Frau.

MISS

ENG

Miss.

MISS

DEU

Frl.

 

The language field parameter (on the table definition tab) is used to designate which of the key fields is a language code field. (the field called "language" in this case).

At run time only the table entries with the correct language code for the user will be displayed.

If multilingual table data is not required, set the language field to the value "No Language Field - Monolingual Table Data". In this case, all table entries will appear at run time. 

A table doesn't necessarily have to be multilingual just because the partition is multilingual.