Index or primary key cannot contain a Null Value

Index or primary key cannot contain a Null Value

Post by Gregc » Thu, 20 Apr 2006 12:05:22


G'day

I wish to make the commitment line times the Primary Key. There are no
duplicates, and the data type is Number. However whenever I try this,
the Error Message 'Index or Primary Key Cannot Contain a Null Value"
appears.

Would anyone know the reason why?

Greg
 
 
 

Index or primary key cannot contain a Null Value

Post by Tom van St » Thu, 20 Apr 2006 12:58:02

On 18 Apr 2006 20:05:22 -0700, "Gregc." < XXXX@XXXXX.COM >


Eh, because there are nulls in that column?
select * from TheTable where [commitment line times] is null

-Tom.

 
 
 

Index or primary key cannot contain a Null Value

Post by Gregc » Thu, 20 Apr 2006 13:02:57


I had blank lines. in the table.

Greg