Numeric Null values in Quiz -
Leslie Tsukamoto
leslie.tsukamoto@cae.com
Tue, 17 Dec 2002 22:47:57 -0600
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C2A64F.C6B5B1FE
Content-Type: text/plain;
charset="iso-8859-1"
We are running an older version of Quiz (7.33.d3) on an Hp9000 and accessing
an Oracle 7.3.4 database. Recently we added a few new columns onto an
existing table. These columns are indicators that allow us to track if a
customer is a us-citizen or not. When the new columns were added, each
existing record then had a null value in that column - it was decided to
test in our application that if the column was null when the the record was
being updated - we would force the user to update that field as well and to
set it to either (no = 0) or (yes = 1). This has worked fine from a front
end application perspective - however, in trying to report within quiz a
listing of all customers and a value of Yes, No, or ? for the 'us-indicator'
field, we found that pretty much everyone was showing up on our report as No
- upon further investigation - it appears that Quiz is (on it's own)
apparently determining if we have a numeric field and the value is null -
quiz assumes it to be 0 - we are unable to successfully test against a null
value on that field even though we can with sqlplus and other applications.
Can someone tell me - is there something that we can do to have quiz
recognize these column values as Nulls so that we can determine which
records have been updated to a true NO value and which ones haven't been
updated at all ? We have been forced to code this particular report in
sqlplus which deviates from the normal deployment of reporting.
I am not sure if there is a dictionary setting that we can utilize or not -
any ideas?
Sincerely, Leslie
Leslie J. Tsukamoto
Manager of Programming, CAE SimuFlite
ph: 407-445-0226
fax: 407-295-9493
email: leslie.tsukamoto@cae.com
------_=_NextPart_001_01C2A64F.C6B5B1FE
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4807.2300" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=091554104-18122002><FONT face=Arial size=2>We are running an
older version of Quiz (7.33.d3) on an Hp9000 and accessing an Oracle 7.3.4
database. Recently we added a few new columns onto an existing
table. These columns are indicators that allow us to track if a customer
is a us-citizen or not. When the new columns were added, each existing
record then had a null value in that column - it was decided to test in our
application that if the column was null when the the record was being updated -
we would force the user to update that field as well and to set it to either (no
= 0) or (yes = 1). This has worked fine from a front end application
perspective - however, in trying to report within quiz a listing of all
customers and a value of Yes, No, or ? for the 'us-indicator' field, we found
that pretty much everyone was showing up on our report as No - upon further
investigation - it appears that Quiz is (on it's own) apparently determining if
we have a numeric field and the value is null - quiz assumes it to be 0 - we are
unable to successfully test against a null value on that field even though we
can with sqlplus and other applications. </FONT></SPAN></DIV>
<DIV><SPAN class=091554104-18122002><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=091554104-18122002><FONT face=Arial size=2>Can someone tell me
- is there something that we can do to have quiz recognize these column values
as Nulls so that we can determine which records have been updated to a true NO
value and which ones haven't been updated at all ? We have been forced to
code this particular report in sqlplus which deviates from the normal deployment
of reporting.</FONT></SPAN></DIV>
<DIV><SPAN class=091554104-18122002><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=091554104-18122002><FONT face=Arial size=2>I am not sure if
there is a dictionary setting that we can utilize or not - any
ideas?</FONT></SPAN></DIV>
<P><FONT face="Monotype Corsiva">Sincerely, Leslie</FONT> </P>
<P><FONT face="Monotype Corsiva">Leslie J. Tsukamoto</FONT> <BR><FONT
face="Monotype Corsiva">Manager of Programming, CAE SimuFlite</FONT> <BR><FONT
face="Monotype Corsiva">ph: 407-445-0226</FONT> <BR><FONT
face="Monotype Corsiva">fax: 407-295-9493</FONT> <BR><FONT
face="Monotype Corsiva">email: leslie.tsukamoto@cae.com</FONT> </P>
<DIV> </DIV></BODY></HTML>
------_=_NextPart_001_01C2A64F.C6B5B1FE--