By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,930 Members | 1,269 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,930 IT Pros & Developers. It's quick & easy.

Index or primary key cannot contain a Null Value

P: n/a
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

Apr 19 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 18 Apr 2006 20:05:22 -0700, "Gregc." <gr*********@bigpond.com>
wrote:

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

-Tom.

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


Apr 19 '06 #2

P: n/a

Tom van Stiphout wrote:
On 18 Apr 2006 20:05:22 -0700, "Gregc." <gr*********@bigpond.com>
wrote:

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

-Tom.


I had blank lines. in the table.

Greg

Apr 19 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.