CivilizationAce
Warlord
- Joined
- Jan 17, 2017
- Messages
- 236
Here's my conundrum:
I want to change the text for a Policy, but I also want to stick with the localisation. i.e. I'd like to create a string as XML, e.g. LOC_MYNEWSTRING. Then update the existing string:
update LocalizedText
set Text = Text || ' ' || (
select L.Text
from LocalizedText as L
where L.Language = LocalizedText.Language
and L.Tag = 'LOC_MYNEWSTRING'
)
where Tag = 'LOC_EXISTINGSTRING'
and exists (
select *
from LocalizedText as L
where L.Language = LocalizedText.Language
and L.Tag = 'LOC_MYNEWSTRING'
);
However, without producing any database errors, this doesn't do anything, so I suspect that it's running before the XML. Anyone know how/if I can set the SQL to run after the XML?
I want to change the text for a Policy, but I also want to stick with the localisation. i.e. I'd like to create a string as XML, e.g. LOC_MYNEWSTRING. Then update the existing string:
update LocalizedText
set Text = Text || ' ' || (
select L.Text
from LocalizedText as L
where L.Language = LocalizedText.Language
and L.Tag = 'LOC_MYNEWSTRING'
)
where Tag = 'LOC_EXISTINGSTRING'
and exists (
select *
from LocalizedText as L
where L.Language = LocalizedText.Language
and L.Tag = 'LOC_MYNEWSTRING'
);
However, without producing any database errors, this doesn't do anything, so I suspect that it's running before the XML. Anyone know how/if I can set the SQL to run after the XML?