Choosing blank fields in Quiz (7.29C)

[Rohde Dirk (Van)]

What kind of database are you using?  I know when we used RMS on the Vax
with an older version of PowerHouse that a statement like yours below would
have worked just fine for picking out the records with a blank field,
however, when we use an Oracle database (on HP/UX or AIX), the statement
chooses all the records.  You only need to specify a single blank between
the quotes to get only the records with the blank field, not all six spaces.

Dirk Rohde
VantagePoint Group

-----Original Message-----
From: Kim Williams [mailto:kim.williams@ashtech.COM]
Sent: Tuesday, December 22, 1998 3:18 PM
To: powerh-l@lists.swau.edu
Subject: Choosing blank fields in Quiz (7.29C)



I have a program that I wrote that the company has been using without any 
complaints for two and a half years.  One of the first statements is to
"CHOOSE"
all the items in a subfile that have the field "FEDR" blank.  I wrote the 
statement as follows:

CHOOSE FEDR ""

It happens to be a six character item.  I probably should have written it as
six
blank spaces between the quotes, but I thought it worked.  I think it
probably 
did work at one time, because the result would have been pretty obviously
wrong 
otherwise.  What actually happens is *all* the records are chosen.  I have 
printouts dating to this program's birth and it has always been this way so
what
happened?  We haven't installed any Quiz patches in a long time (currently 
version 7.29C).  We have been regularly updating our MPE operating system so

that has changed from time to time (C.55.00 and I think we are on powerpatch
4 
right now).

So do you think this *never* worked right and my users (and me) are 
spectacularly unobservant?  Or could something in my environment have
changed 
and changed how my Quiz statement worked?

Thanks for any help,
Kim Williams 


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