Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Unique Constraints and Foreign Key

Re: Unique Constraints and Foreign Key

From: <suisum_at_freenet.edmonton.ab.ca>
Date: 10 Oct 1998 14:38:30 GMT
Message-ID: <6vnrh6$ehi$1@news.sas.ab.ca> 





Hi:



I find it by myself. Some of the value in field2 and fields 3 are spaces.
It voliates th eforeign key and the unique key constraint.



Best regards,



Frenchy461 (frenchy461_at_aol.com) wrote:



: If field 2 and 3 are spaces(null fields), it will allow to insert record with


: nulls. The foreign key validation only happens when a value is entered in the


: fields.





--


Best regards,
Received on Sat Oct 10 1998 - 09:38:30 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US