Shalom Elkin <[email protected]> wrote: > id 3 doesn't exist, the insertion fails. Now, this was easy. what if > ac.inhad millions of rows? I am looking for some way to get a message > like "error > in line 3: foreign key mismatch".
Write a program that parses the file, runs INSERT statement on each file, and reports any failures. Do it all in a transaction; at the end, roll it back. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
