Choosing blank fields in Quiz (7.29C)

[Robert J.M. Edis]

G'day Kim

I have seen this happen when the option on how to deal with NULL has been
changed in the dictionary.  If you tell the dictionary not to allow NULLs
and convert char fields to a single blank and numeric items to zero, CHOOSE
x "" and CHOOSE x " " behave the same.  If NULLs ARE allowed then CHOOSE x
"" will be treated as "get all records" as opposed to CHOOSE x " " which
means 'select all records where x = blank.

Another issue brought up was the difference between databases;  Oracle 7.n
will match the number of blanks and do other 'funny' things.  I.e. " " <> "
".  Oracle Rdb on the other hand says 1 blank = n blanks.

The issue with Oracle 7 and blank handling is described in Cognos's online
Knowledgebase.

Blue
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.