On 13 Dec 2011, at 3:55pm, jwzumwalt wrote: > I am attempting to crete a trigger that fills a field with "unknown" if a > update leaves it empty.
I assume you know you can assign a default value for a column, so that this becomes the value of the column unless the INSERT sets it, or until an UPDATE sets it. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
