If you MUST do this in a SQL Statement you might give this a try:
Write a virtual table module "SPLIT" with three fields (element, delimiter,
record) that will return the parts of a string from SQL like
SELECT element FROM SPLIT WHERE delimiter = ' ' and record = <your string>;
CREATE VIRTUAL TABLE split USING split('<default delimiter>');
Write a function "JOIN" that will return a string concatenation of its
parameters
JOIN(<delimiter>,<value>...)
The result will be sort of SQL...
-----Ursprüngliche Nachricht-----
Von: Gert Van Assche [mailto:[email protected]]
Gesendet: Freitag, 01. März 2013 07:50
An: sqlite-users
Betreff: [sqlite] update the same record in multiple segments at once
All, I don't know if this is possible.
A segment in table "Files" contains a record "Content" with a fields like this
"XXX AAAA XXXX BBBB YYYY CCCC DDDD"
Needs to become "XXX 123 XXXX 456 YYYY 78 90"
Based on a "Translation" table were I have
AAAA|123
BBBB|456
CCCC|78
DDDD|90
If I do
UPDATE [Files] SET [Content] = replace(Content, (SELECT [Source] FROM
[Translations]), (SELECT [Translation] FROM [Translations]));
only the first match is replaced and I get: "XXX 123 XXXX BBBB YYYY CCCC DDDD"
Is there a way to "translate" BBBB, CCCC and DDDD as well?
thanks
Gert
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--------------------------------------------------------------------------
Gunter Hick
Software Engineer
Scientific Games International GmbH
Klitschgasse 2 – 4, A - 1130 Vienna, Austria
FN 157284 a, HG Wien
Tel: +43 1 80100 0
E-Mail: [email protected]
This e-mail is confidential and may well also be legally privileged. If you
have received it in error, you are on notice as to its status and accordingly
please notify us immediately by reply e-mail and then delete this message from
your system. Please do not copy it or use it for any purposes, or disclose its
contents to any person as to do so could be a breach of confidence. Thank you
for your cooperation.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
