Oracle index with NULL values

[Joe Boyle]

Or even enter @@ in the first segment :-)

 

  _____  

From: Joe Boyle [mailto:atla38 at dsl.pipex.com] 
Sent: 15 January 2007 15:01
To: 'Selfors Bjørn'; 'Powerh-L (E-post)'
Subject: RE: Oracle index with NULL values

 

And if you are accessing a RDB the second access statement can address the
second column whether it is an in index or not. You might even consider
adding a button which runs the ‘select action, the user can then select on
any field on the screen.

 

  _____  

From: Joe Boyle [mailto:atla38 at dsl.pipex.com] 
Sent: 15 January 2007 14:47
To: 'Selfors Bjørn'; 'Powerh-L (E-post)'
Subject: 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/bf07caa1/attachment-0001.htm