On Thu, Aug 03, 2017 at 07:42:12PM -0500, Nico Williams wrote: > On Fri, Aug 04, 2017 at 12:35:56AM +0200, Sylvain Pointeau wrote: > I think some type checking should be done. > > You could just take the argv[] values and bind them directly to the > insert below, and use CHECK constraints on the SP_SEQUENCE table.
This seems best, actually, partly because you can't hide this table and with CHECK constraints you get to make sure that users use the right types in these columns. I do wish SQLite3 had a strict typing mode where the declared type of a column is automatically made into a CHECK constraint. Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
