SV: Oracle index with NULL values

[Selfors Bjørn]

The index is simple:
create index kundeid1 on kunde(kundeid);
and the access statement
ACCESS ...
ACCESS  &
NOGENERIC&
REQUEST KUNDEID OF KUNDE &
USING KUNDEID OF KUNDE &
VIA KUNDEID  
ACCESS...
 
but the KUNDEID field may contain NULL values
 
Bjørn Selfors, Delfi Data a.s. 


-----Opprinnelig melding-----
Fra: Joe Boyle [mailto:atla38 at dsl.pipex.com]
Sendt: 15. januar 2007 15:47
Til: Selfors Bjørn; 'Powerh-L (E-post)'
Emne: RE: Oracle index with NULL values



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/5b3befa0/attachment.htm