2015-12-13 13:52 GMT+01:00 R Smith <rsmith at rsweb.co.za>: > > > On 2015/12/13 2:17 PM, Cecil Westerhof wrote: > >> I am continuing with my exploration of SQLite. :-) >> >> 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? >> > > No. > > Foreign Key checks only happen on data changes. I don't think there would > be a point of turning off FK checks, adding non-relation data to the > tables, then turning it back on, and simply get a permanent error condition. >
?I agree, but you never know what someone else is doing. ? -- Cecil Westerhof