Hello, The B_FK foreign key is defined to allow NULLs. This foreign key contains a primary key value that don't allow NULLs.
Suppose you enter a NULL value into the B_FK foreign key. If you want to be logic it should normally have a NULL value as primary key in the table where the foreign key is assigned, or not? Thank you Regards Sylvain -----Message d'origine----- De: Laurie Harper [mailto:[EMAIL PROTECTED]] Date: vendredi, 20. d�cembre 2002 18:08 �: [EMAIL PROTECTED] Objet: Re: [PB] associations and storing objects [EMAIL PROTECTED] wrote: > Do I have to insert a B_FK value or could I have a NULL value in this > field? > In other words: is the B_FK value mandatory? Depends how you define it in your database schema. If it is defined as NOT NULL then it can't have a NULL value and so is mandatory. If you don't specify such a constraint, it wont be enforced. L. -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
