[sqlite] UPDATE and default values

works for INSERTs, but seems not to work for UPDATEs. Is that right? What to do? Ulrich -- Ulrich Goebel Paracelsusstr. 120, 53177 Bonn ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Combining two databases into one

er: 3917021 Registered in England and Wales. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Ulrich Goebel Paracelsusstr. 120, 53177 Bonn ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Handling Pictures

in both directions. By the way: Even Qt has a QtSql module, but for the moment I prefere to use the apsw module... Every hint is welcome! Ulrich -- Ulrich Goebel Paracelsusstr. 120, 53177 Bonn ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Groups and members

That gives me the solution - thank You! Am 06.11.2013 14:45, schrieb Igor Tandetnik: On 11/6/2013 6:55 AM, Ulrich Goebel wrote: Now my problem: For a given person (that is a given p_id) I would like to get a list of all (!) groups, marked wether p_id is a member of it or not. If p_id=1 and

[sqlite] Groups and members

with p_id in it come first and are sorted, then come the groups with p_id not in it, sorted too. Is it a matter of a "simple" SELECTs with joined tables? Have I to think about subqueries? Or even Compund SELECTs (UNION, INTERSECT)? It would be great to get some hints! Ulrich -- Ul

[sqlite] collation for german "Umlaute"

apsw instead of the SQL-script and .read. Right? The background is very simple: in my db I store german people with their name, address and so on, and there are these "Umlaute" in the names, and the row name has its own index. Now I brought more text then I would like to... but I ho

[sqlite] SQLite "Frontend"?

tered, so the can be recalled an edidet later by the arrow-keys. At the time I have to hack the entire command again - and that is ab bit ... Any idea? Greetings Ulrich -- Ulrich Goebel Paracelsusstr. 120, 53177 Bonn ___ sqlite-users mailing list s