U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » Community » Newbie corner » Translation files

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Re: Translation files [message #54968 is a reply to message #54965]

Fri, 02 October 2020 12:04

idkfa46
Messages: 155
Registered: December 2011

Experienced Member

Ciao Mirek,
thank your for your feedback. I try to better explaining the situation...

1 - At the moment I have a database that contain text in a t_() macro and at the first run the database is create with the user language
2 - If the user change the language setting and restart the tool all the software change language making exception for the database text
3 - At this stage I have a few queries like this one that fails because the match "s" = "CATEGORIA" doesn't work (it's a different language!)

double Impostazioni::GetPsi0j(String s)
{
	SQL * Select(PSI0j).From(COEFCOMBIN).Where(CATEGORIA == s);	return SQL[PSI0j];
}

4 - To solve it I have to update the text translation in the database... To reset de database to default setting is the easiest way but I gonna lose possible user settings!

My question:

Is there a trick to force database translation update?
I have to read and update it row by row? In that case is it possible to read the database text with a Select * and Update the translation without going throught the T_("") language with something like this?

try
{
	SQL * Select(CATEGORIA).From(COEFCOMBIN);
		
	while(SQL.Fetch())
	{			
		SQL & ::Update(COEFCOMBIN)(CATEGORIA, t_(SQL[CATEGORIA])).Where(CATEGORIA == SQL[CATEGORIA]);		
	}	
}

Thanks,
Matteo

Report message to a moderator

Re: Translation files [message #54978 is a reply to message #54968]

Sat, 03 October 2020 04:38

mirek
Messages: 14255
Registered: November 2005

Ultimate Member

idkfa46 wrote on Fri, 02 October 2020 12:04

Ciao Mirek,
thank your for your feedback. I try to better explaining the situation...

1 - At the moment I have a database that contain text in a t_() macro and at the first run the database is create with the user language

I guess you might got this a bit wrong, perhaps you see a magic in t_ that is not there.. All that t_ does is that it might return different string literal. So your database contains texts, period.

Quote:

Is there a trick to force database translation update?
I have to read and update it row by row? In that case is it possible to read the database text with a Select * and Update the translation without going throught the T_("") language with something like this?

Basically, yes.

Maybe you can delete the whole table content and insert new values?

All that said, this design, depending on translation, feels pretty awful. What about defining some integer constants instead of texts?

Alternatively, what about having these texts in DB in english and do the eventual translation in the application?

Mirek

Report message to a moderator

Re: Translation files [message #55051 is a reply to message #54978]

Wed, 07 October 2020 13:35

idkfa46
Messages: 155
Registered: December 2011

Experienced Member

In the end I go to reset the whole database at the language change... I'm implementing and old project not structured for multilanguage and the db changes impacts everywhere... Laughing

Thanks,
Matteo

Report message to a moderator

Pages (2): [ « ‹ 1 2]

Previous Topic:	Simple Thread
Next Topic:	Create exe from Windows to Linux

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Apr 25 12:53:21 CEST 2025

Total time taken to generate the page: 0.00541 seconds