Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to set up a multilingual environment (dutch - french). In my database I always have 2 columns for a caption or a name. One is suffixed with _NL, the other with _FR. Instead of selcting both columns I would like to select only one depending on a language variable.
LOAD "CAMPUS_ID",
"CAMPUS_NR",,
"CAMPUS_NAME_NL",
"CAMPUS_NAME_FR";
SQL SELECT "CAMPUS_ID",
"CAMPUS_NR",
"CAMPUS_NAME_NL",
"CAMPUS_NAME_FR"
FROM dbo."REF_CAMPUS_V";
Can someone help me out here? !
Let vLang = '_NL'; //Change this according to your need
LOAD "CAMPUS_ID",
"CAMPUS_NR",
"CAMPUS_NAME$(vLang)";
SQL SELECT "CAMPUS_ID",
"CAMPUS_NR",
"CAMPUS_NAME$(vLang)"
FROM dbo."REF_CAMPUS_V";