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. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users