<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18876"></HEAD>
<BODY>
<DIV><SPAN class=671051319-11022010><FONT size=2
face=Arial>Hello,</FONT></SPAN></DIV>
<DIV><SPAN class=671051319-11022010><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=671051319-11022010><FONT size=2 face=Arial> I just
noticed something strange converting to Oracle 8, using Powerhouse 8.40.D1,
when selecting a null value in one table, where multiple tables are
involved. It doesn't seem to work ! Either I have to limit the SELECT to just
that table with the null, or code an additional statement "SELECT
file IF field IS NULL" for that table. Or I can use a define
setting it to 0 when that field is null and use the define in the select.
So I have the work arounds, but just curious what's going on
?</FONT></SPAN></DIV>
<DIV><SPAN class=671051319-11022010><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=671051319-11022010><FONT size=2
face=Arial>ie.</FONT></SPAN></DIV>
<DIV><SPAN class=671051319-11022010><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=671051319-11022010><FONT size=2 face=Arial>Access
Oracle_table_1 &</FONT></SPAN></DIV>
<DIV><SPAN class=671051319-11022010><FONT size=2 face=Arial> Link
to <SPAN class=671051319-11022010><FONT size=2
face=Arial>Oracle_table_2</FONT></SPAN> opt</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=671051319-11022010><FONT size=2 face=Arial>Select if field of
Oracle_table_1 = "Y" and &</FONT></SPAN></DIV>
<DIV><SPAN class=671051319-11022010><FONT size=2 face=Arial> field of
Oracle_table_2 IS NULL</FONT></SPAN></DIV>
<DIV><SPAN class=671051319-11022010><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=671051319-11022010><FONT size=2 face=Arial>Doesn't work, Will
always return 0 records !!</FONT></SPAN></DIV>
<DIV><SPAN class=671051319-11022010><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=671051319-11022010><FONT size=2 face=Arial>But the following
will work and return some records</FONT></SPAN></DIV>
<DIV><SPAN class=671051319-11022010><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=671051319-11022010><FONT size=2 face=Arial>1) Select if field
of Oracle_table_2 IS NULL</FONT></SPAN></DIV>
<DIV><SPAN class=671051319-11022010><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=671051319-11022010><FONT size=2 face=Arial>2) <SPAN
class=671051319-11022010><FONT size=2 face=Arial>Select if field of
Oracle_table_1 = "Y"</FONT></SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=671051319-11022010><FONT size=2 face=Arial>
Select <SPAN class=671051319-11022010><FONT size=2 face=Arial>Oracle_table_2 if
field of Oracle_table_2 IS NULL</FONT></SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=671051319-11022010><FONT size=2 face=Arial><SPAN
class=671051319-11022010></SPAN></FONT></SPAN> </DIV>
<DIV><SPAN class=671051319-11022010><FONT size=2 face=Arial><SPAN
class=671051319-11022010>3) DEFINE D_FIELD = field of Oracle_table_2
&<BR> IF NOT field of
Oracle_table_2 IS NULL ELSE 0</SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=671051319-11022010><FONT size=2 face=Arial><SPAN
class=671051319-11022010> </SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=671051319-11022010><FONT size=2 face=Arial><SPAN
class=671051319-11022010> <SPAN class=671051319-11022010><FONT
size=2 face=Arial>Select if field of Oracle_table_1 = "Y" and
&</FONT></SPAN>
<DIV><SPAN class=671051319-11022010><FONT size=2
face=Arial> D_FIELD = 0</FONT></SPAN></DIV>
<DIV><SPAN class=671051319-11022010></SPAN> </DIV>
<DIV><SPAN class=671051319-11022010> (This will work for me since
the field is actually a date type which cannot be 0 in the first
place</SPAN></DIV>
<DIV><SPAN class=671051319-11022010></SPAN> </DIV>
<DIV><SPAN class=671051319-11022010></SPAN> </DIV>
<DIV><SPAN class=671051319-11022010>Thanks</SPAN></DIV>
<DIV><SPAN class=671051319-11022010></SPAN> </DIV>
<DIV><SPAN class=671051319-11022010>Dan</SPAN></DIV></SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=671051319-11022010><FONT size=2 face=Arial><SPAN
class=671051319-11022010> </DIV>
<DIV><BR></DIV></SPAN></FONT></SPAN>
<DIV><SPAN class=671051319-11022010><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=671051319-11022010><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=671051319-11022010><FONT size=2
face=Arial></FONT></SPAN> </DIV></BODY></HTML>