<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word"><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Oracle index with NULL values</TITLE>
<META content="MSHTML 6.00.2800.1505" name=GENERATOR><!--[if !mso]>
<STYLE>v\:* {
BEHAVIOR: url(#default#VML)
}
o\:* {
BEHAVIOR: url(#default#VML)
}
w\:* {
BEHAVIOR: url(#default#VML)
}
.shape {
BEHAVIOR: url(#default#VML)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
font-family: Tahoma;
}
@page Section1 {size: 595.3pt 841.9pt; margin: 72.0pt 90.0pt 72.0pt 90.0pt; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; FONT-FAMILY: "Times New Roman"; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
SPAN.EmailStyle18 {
FONT-WEIGHT: normal; COLOR: blue; FONT-STYLE: normal; FONT-FAMILY: Arial; TEXT-DECORATION: none; mso-style-type: personal-reply
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-GB vLink=purple link=blue>
<DIV><SPAN class=492505114-15012007><FONT face=Arial color=#0000ff size=2>The
index is simple:</FONT></SPAN></DIV>
<DIV><FONT face=Arial><FONT size=2><FONT color=#0000ff><SPAN
class=492505114-15012007>create index kundeid1 on
kunde(kundeid)</SPAN>;</FONT></FONT></FONT></DIV>
<DIV><SPAN class=492505114-15012007><FONT face=Arial color=#0000ff size=2>and
the access statement</FONT></SPAN></DIV>
<DIV><SPAN class=492505114-15012007><FONT face=Arial color=#0000ff size=2>ACCESS
...</FONT></SPAN></DIV>
<DIV><SPAN class=492505114-15012007><FONT face=Arial color=#0000ff
size=2>ACCESS &<BR>NOGENERIC&<BR>REQUEST KUNDEID OF KUNDE
&<BR>USING KUNDEID OF KUNDE &<BR>VIA KUNDEID
<BR>ACCESS...</FONT></SPAN></DIV>
<DIV><SPAN class=492505114-15012007><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=492505114-15012007><FONT face=Arial color=#0000ff size=2>but
the KUNDEID field may contain NULL values</FONT></SPAN></DIV>
<DIV><SPAN class=492505114-15012007></SPAN> </DIV>
<DIV><FONT face=Arial size=2>Bjørn Selfors, Delfi Data a.s.</FONT> <BR></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Opprinnelig melding-----<BR><B>Fra:</B> Joe Boyle
[mailto:atla38@dsl.pipex.com]<BR><B>Sendt:</B> 15. januar 2007
15:47<BR><B>Til:</B> Selfors Bjørn; 'Powerh-L (E-post)'<BR><B>Emne:</B> RE:
Oracle index with NULL values<BR><BR></FONT></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Arial">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.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<DIV>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><FONT
face="Times New Roman" size=3><SPAN lang=EN-US style="FONT-SIZE: 12pt">
<HR tabIndex=-1 align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P class=MsoNormal><B><FONT face=Tahoma size=2><SPAN lang=EN-US
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">
powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com] <B><SPAN
style="FONT-WEIGHT: bold">On Behalf Of </SPAN></B>Selfors Bjørn<BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> 15 January 2007 11:22<BR><B><SPAN
style="FONT-WEIGHT: bold">To:</SPAN></B> Powerh-L (E-post)<BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> Oracle index with NULL
values</SPAN></FONT><SPAN lang=EN-US><o:p></o:p></SPAN></P></DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hi all!</SPAN></FONT> <BR><FONT
face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">(Axiant
3.1, Windows, Oracle)</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">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.</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">How do I avoid this
error?</SPAN></FONT> <o:p></o:p></P>
<P><FONT face=Arial color=gray size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: gray; FONT-FAMILY: Arial">mvh/regards</SPAN></FONT>
<BR><FONT face=Arial color=gray size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: gray; FONT-FAMILY: Arial">Bjørn
Selfors,</SPAN></FONT> <o:p></o:p></P></DIV></BLOCKQUOTE></BODY></HTML>