Mastering PowerBuilder

HomePrevious Lesson: Course 3:: Session 27 :: Page 210
Next Lesson: Course 3:: Session 27 :: Page 230
Translation Dictionary

Translation Dictionary

Translation dictionary stores translations for words and phrases from/into different languages. The more you populate this dictionary, the more it is helpful while translating your application into the target language. At translation time it uses the word/phrase to find a correct match, otherwise it tries to find out on the partial match and prompts you. This dictionary 'xldictionary' is maintained in SQL AnyWhere database 'PBELDICT.DB' and has the following schema:

Column Name Contents Comments
text_to_tr_key Source text key Must be in uppercase
language_from Source language Must be in uppercase
language_to Target language Must be in uppercase
text_to_translate Source text  
translated_text Target text  
tr_text_key Translated text key Must be in uppercase
soundex_key Reserved for future use  

All columns are of string data type. The columns 'language_from' and 'language_to' contains the language suffixes. For example, you may want to use 'F' for French, 'G' for German etc. as the suffix to the translated objects ( w_login_f, w_login_g, etc.). For some reason if you would like to use another database to keep the dictionary, you can use a data pipeline object to copy the dictionary to the target database and change the entries in the [DB] section in the XLUTIL.INI file to point to the new database.

HomePrevious Lesson: Course 3:: Session 27 :: Page 210
Next Lesson: Course 3:: Session 27 :: Page 230