Thank you both!
2013/3/1 Hick Gunter <h...@scigames.at>
> 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:ger...@datamundi.be]
> 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
> sqlite-users@sqlite.org
> 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: h...@scigames.at
>
> 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
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
