On Mon, 04 Aug 2008 12:47:24 +0100, you wrote: >Thanks Emilio and Kees for doing what should have done - a bit of basic >SQL! > >Well the problem has been narrowed down to the the Show Table/Modify >Data function in SQLit3Manager. If I just do a simple insert from there >the default text does not appear. The numeric defaults are ok however. >Maybe the "insert puts a ' ' into the field in which case it is not >empty - I have no way of knowing.
I think you nailed it right there. The problem with many of those frontends is, they have no way to represent a missing value. The form has all columns, and if you enter nothing, the INSERT still wants to offer all columns to the database and the empty string is passed as a value. You could build a workaround using triggers. Then the trigger could supply default values for all empty strings. Not nice, but it might work for you. >Thanks for you help. > >David -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
