Re: [sqlite] Data deleted

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

Re: [sqlite] Data deleted

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,

Re: [sqlite] Data deleted

Thanks for that. Although that disables the DDL trigger, on running the import I get a abort due to constraint violation error: Exception: - 2.1 Date : Wed, 10 Aug 2011 13:35:56 +0100 2.2

Re: [sqlite] Data deleted

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

Re: [sqlite] Data deleted

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

Re: [sqlite] Data deleted

Malcolm Lander 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