[sqlite] german locale: queries calculated float fields deliver wrong dec.sep.

do Gerald -- ___ Gerald Ebner Lieu dit Les Sauzines 31460 Auriac sur Vendinelle tel. 05 34 66 97 75 / 06 35 94 53 50 email: geraldo.eb...@gmail.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bi

Re: [sqlite] update - select

Moved; > > > Pavel > > On Tue, Sep 1, 2009 at 2:54 PM, Gerald Ebner<geraldo.eb...@gmail.com> wrote: > >> hm, finally I'm looking for a convenient way to execute update-selects, >> very helpful in doing synchronization between different databases >> >

Re: [sqlite] update - select

, City= m.City FROM Customers AS c INNER JOIN Moved AS m ON m.SSN = c.SSN; is this syntax supported by sqlite ? do you know any other convenient way to execute update-selects? many thanks in advance Geraldo Igor Tandetnik wrote: > Gerald Ebner <geraldo.eb...@gmail.com>

Re: [sqlite] update - select

; On Thu, Aug 20, 2009 at 12:01 PM, Gerald Ebner<geraldo.eb...@gmail.com> wrote: > >> Dear all, >> >> it seems that sqlite does not allow update statements of this kind: >> >> UPDATE table_1 SET (field_a, field_b, field_c, field_d) = ( >>SE

[sqlite] update - select

Dear all, it seems that sqlite does not allow update statements of this kind: UPDATE table_1 SET (field_a, field_b, field_c, field_d) = ( SELECT field_a, field_b, field_c, field_d FROM table_2 WHERE … ) WHERE I succeeded only with UPDATE table_1 SET field_a = (SELECT field_a FROM