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? On 10/08/2011 13:14, Igor Tandetnik wrote: > Malcolm Lander<land...@blueyonder.co.uk> wrote: >> I have just tried using SQLite pro. In the existing database I am >> trying to manipulate there are several tables. On trying to import a >> .csv file into one of them and replacing the current data in that table >> it works OK. >> >> However, all the data in one of the other tables also gets deleted >> during the operation. Why is this? > > There's either a trigger doing the deletion, or a foreign key with ON DELETE > CASCADE clause. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
