> Your TEXT NOT NULL fields should be declared as TEXT NOT NULL COLLATE > NOCASE. This will simplify your programming later.
I think I am going to write python scripts to use those with my database. For start I find this: http://zetcode.com/db/sqlitepythontutorial/ <http://zetcode.com/db/sqlitepythontutorial/> I think I could this way add few hundreds of rows to the 'uniqueworkpiece' by running such a script. Thank you all for help on this thread! ----- Best, Pál -- Sent from: http://sqlite.1065341.n5.nabble.com/ _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users