Sv: Numeric Null values in Quiz -

[Ole Hansen]

Hi Leslie,

Have you tried using 'IF itemname IS NULL', e.g. in QUIZ or QTP :

DEFINE USCITIZEN CHAR*12 = "UNDETERMINED" if us_indicator IS NULL &
                     ELSE  "NO"  if us_indicator = 0              &
                     ELSE  "YES" if us_indicator = 1              &
                     ELSE  "ERROR"

HTH.

Mange hilsner / With kind regards

Ole Hansen

===========================================================
E-mail: oh@scanconsult.dk         Cell Phone: +45 4040 1150
===========================================================
ScanConsult IT-Partners ApS         Voice   : +45 8738 7474
Jegstrupvej 96A                     Fax     : +45 8738 7475
DK-8361 Hasselager         Support : support@scanconsult.dk
Denmark                    Sales   :   sales@scanconsult.dk
                 http://www.scanconsult.dk                
= ParaSuite :  A Suite of Air Cargo Handling solutions    =
= ParaSafe  :  A Suite of IT-Security solutions           =
= Partners  : Hewlett-Packard, Cognos, Microsoft and more =

-----Original Message-----
From: Leslie Tsukamoto <leslie.tsukamoto@cae.com>
To: powerh-l@lists.swau.edu <powerh-l@lists.swau.edu>
Date: Wednesday, December 18, 2002 5:55 AM
Subject: Numeric Null values in Quiz - 


>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 
>
> 
>