Monday, March 11, 2019, 6:59:56 PM, E.Pasma <[email protected]> wrote:
> I can confirm that this has nothing to do with the sqlite version, > as it is so in the tcl binding from the current release (3.28.0.). > There is no "mode" method or paramater like in the shell. I'd > probably work around this by an update in SQL, after the import. Or > import into a view, with an "instead of insert" trigger to insert > cleaned data into the table. > Sorry, E. Pasma. Thanks for the confirmation. For what I'm doing (a mostly one-off data import) a sufficient work-around is to use Tcl to "exec" the SQLite shell and have it run ".import". Regards, Graham Holden _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
