Malcolm Lander <[email protected]> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
