Oracle index with NULL values

[Joe Boyle]

Probably, and assuming that the index has at least two segments, the easiest
way would be to add the second segment as a repeating index in its own
right, and then add a second access statement for the new index.

 

  _____  

From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf Of
Selfors Bjørn
Sent: 15 January 2007 11:22
To: Powerh-L (E-post)
Subject: Oracle index with NULL values

 

Hi all! 
(Axiant 3.1, Windows, Oracle) 
I have added an index to a table (field includes null values), and I have
added an access statement in my screen.  But when testing it, I get the
error "Use SELECT to find NULL values" when I enter the TAB, planning to
enter some value in the next request field.

How do I avoid this error? 

mvh/regards 
Bjørn Selfors, 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20070115/7461fd95/attachment.html