Multi lingual SQL with Translate App
In this video I'll show you how to generate sql code with my Translate App.
If you have for example a web site with products and you decide to translate them to more languages you could make your database program generate insert statements for your product records.
I'll write a simple insert just for the test.
insert into product(from,to,lang) values ('from', 'to','bg_BG');
So instead of the translatable texts you put a dollar sign $ and the name of the key from the table below. And instead of the language code you put '$lang'
Then you save your collection and click generate.
I'll open the file and as you can see you now have insert statements for all the languages supported by the app. The Sql operation that you need is entirely on you. The only quirk here is to place the keys as variables with dollar and the language as $lang.
http://tomavelev.com/TranslateApp/