Thanks again, I will have a go at that


On 10/08/2011 13:53, Simon Slavin wrote:
>
> 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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to