codebyo (10/25/2011)
Almost got it wrong because I couldn't see the error in query #7 (there were 5 values being passed to 4 columns).
#7 fails because personname is declared NOT NULL in the table def, I believe.
Nice question. Didn't realize that FK constraints aren't checked if a NULL is present, as I don't recall having declared a FK on columns where I allowed nulls.
[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn