On 10 Aug 2011, at 1:27pm, Malcolm Lander wrote: > Thanks for the reply. It looks like this in the DDL is the culprit: > > CREATE TRIGGER [AircraftIDdeltrig] > BEFORE DELETE > ON [Aircraft] > FOR EACH ROW > BEGIN DELETE FROM Flights WHERE AircraftID = OLD.AircraftID;END; > > Is there a way to disable it?
Issue the SQLite command DROP TRIGGER AircraftIDdeltrig Once you've done your import, to restore functionality, reissue the 'CREATE TRIGGER' command as shown above. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users