|
<< Click to Display Table of Contents >> Navigation: Drawings > Drawing Title Blocks > Localization of Variant Notes |
Variant notes definitions for simple fields or "SELECT …" queries support different language localizations from a single cross-language definition.
The following syntaxes and workarounds are supported:
1.the English language DRAWING. And DOCUMENT. table identifiers are always accepted for the definitions
2.field names can always be expressed in the ?NAME_FIELD_... format
•For the Italian database localization, a variant note definition such as:
@DBW=DISEGNO.DESCRIZIONE
can be written also as:
@DBW=DRAWING.?NAME_FIELD_DESCRIPTION
•For the Italian database localization, a SQL-Query definition such as:
@DBW=SELECT DESCRIZIONE FROM DOCUMENTO WHERE UNIQUE_ID=(DISEGNO.UNIQUE_ID)
can be written also as:
@DBW= SELECT $(?NAME_FIELD_DESCRIPTION) FROM $(?NAME_DOCUMENT_TABLE) WHERE $(?NAME_FIELD_UNIQUE_ID)=(DRAWING.?NAME_FIELD_UNIQUE_ID)
•For the Italian database localization, a variant note using the $LASTREV() macro such as:
@DBW=SELECT $LASTREV(APPROVATO_DA)
can now be expressed as:
@DBW= SELECT $LASTREV(?NAME_FIELD_APPROVED_BY)
In all the above samples, the result is identical for the two formats (this enhancement is backward compatible), but writing the variant note in the second format will allow it to be LANGUAGE INDEPENDENT on supported languages (English, Italian, German, French and Spanish).