Oracle index with NULL values

[Joe Boyle]

In that case it might be the path proc is messed up. Take a look in the qkr
file (created at compilation) to confirm that the path proc details are
being generated correctly.

 

  _____  

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 14:59
To: Joe Boyle; Powerh-L (E-post)
Subject: SV: Oracle index with NULL values

 

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/d39b3ea3/attachment.html