Adam, > Is there a primary key on the table? > > Is it possible to use insert or replace instead of update, and then not > reference the column you want to set as a default?
An interesting idea. Unfortunately, I think in my case it would be too much of a performance hit since I would be updating many many rows at one time (totalling many mb of data) and I *think* that sqlite would choke over that. But I will give it a go... thanks. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
