2015-12-13 13:53 GMT+01:00 Dominique Devienne <ddevienne at gmail.com>:
> On Sun, Dec 13, 2015 at 1:17 PM, Cecil Westerhof <cldwesterhof at gmail.com> > wrote: > > > At the moment I am working with Foreign Keys. They need to be enabled. > When > > you do not do this it is possible to enter records that break the Foreign > > Key rules. Is there a way to check for this. > > > > For example in a session where Foreign Keys where not enabled I did the > > first INSERT from: > > https://www.sqlite.org/foreignkeys.html > > > > When opening the database in a session with Foreign Keys enabled, is > there > > a method to find this record that breaks the rules? > > > https://www.sqlite.org/pragma.html#pragma_foreign_key_check > ?That is very interesting information. Thanks. -- Cecil Westerhof