Home -> Usenet -> comp.databases.oracle -> Help with CONSTRAINTS..

Help with CONSTRAINTS..

From: James Johnson <radar_at_busadm1.cba.hawaii.edu>
Date: Wed, 9 Dec 1992 02:37:39 GMT
Message-ID: <radar.367_at_busadm1.cba.hawaii.edu> 






                        ORACLE ENVIROMENT


I am currently running Kernel Version 6.0.31.2.2 on a OS/2 server with 
DOS clients. Tools are:

			Forms 		3.0.16
			ReportWriter	1.1.12
			Plus		3.0.9
			Menu		5.0.11
			NetSPX		1.1.0.9
		 




I'm having problems enforcing constraints. What I'ld like to do is create 
table to enforce a Yes or No  ('Y','N') flag. Easy enough to do through 
SQL*Forms, but I'ld like to handle with a constraint.



This is what I tried.


        Create table A (FLAG char(1) primary key);
        

	Insert into A values ('Y');
	Insert into A values ('N');

	Create table BB (Test Char(1) NOT NULL, 
		References A ( FLAG )
		Constraint FLAG_CHK);

	Insert into BB values ('F');  /* Should fail */
		One row created;





Can anyone tell me what I'm doing wrong? I would like to use this type 
of constraint more often but get a simple one to work.



Thanks in advance,


Jim 	
Received on Wed Dec 09 1992 - 03:37:39 CET












Original text of this message