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
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
2.9 Status: New
2.10 Note :
On 10/08/2011 13:29, Simon Slavin wrote:
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
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