On 10 Aug 2011, at 1:39pm, Malcolm Lander wrote: > Thanks for that. Although that disables the DDL trigger, on running the > import I get a abort due to constraint violation error:
You will probably need to import data into the TABLEs in an order that suits the data hierarchy. For instance, the TRIGGER you deleted implies that you will need to put data into the Aircraft TABLE before the Flight TABLE. I don't know what other tables you have, but similar logic might apply to those too. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users