Quick Screen Index Retrieval Mystery

Jones Allen (Van) Allen.Jones@vpgroup.com
Mon, 12 Apr 1999 13:08:35 -0700


Sometimes I find it necessary to comment out more and more of the "real"
screen until it starts working, then I know that the last thing I commented
out probably is at fault.  Make a copy of the failing screen and begin
commenting chunks of the source and gradually turn your screen into the
default screen.  At some point, your screen will start working.  Then add
back the parts that you commented that didn't make the error go away.  This
will help you focus on the failing part.  You get the idea, I'm sure.

-----Original Message-----
From: Jayson Garrett [mailto:Garrett@mc.edu]
Sent: April 12, 1999 12:41 PM
To: powerh-l@lists.swau.edu
Subject: Quick Screen Index Retrieval Mystery


Platform: PowerHouse 7.09.E, MPE/iX 5.5, KSAM/XL file

We've got a mystery on our hands here, in which users of a certain screen
can retrieve certain records by a specific index value, but some records
return the error "No records were found matching index/selection values."

This would be fine if there indeed were no such record, but that's not the
case. I can report on the same record using the same index retrieval with a
CHOOSE statement in Quiz.

I called Customer Support, and was told to try generating a default screen.
After doing so, I found that the default screen retrieves the records in
question perfectly. This started me thinking about the PATH and FIND
procedures in the production screen, so I examined them, and they're
virtually identical to the ones that QDESIGN generated by default. In fact,
I even went so far as to comment them out entirely, then recompiled, and the
screen *still* wouldn't retrieve the records.

I also thought there may be some KSAM/XL file or index corruption, so I
saved the file as a subfile, deleted, rebuilt, and reloaded it, with no
change in behavior from the screen.

I checked to make sure there are no SELECT statements in the screen that
might have an effect on it as well, and there aren't.

Customer Support is scratching its head at this point, so I thought I'd
throw it out to the list... anyone have any ideas?

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Jayson T. Garrett, Mississippi College Computer Center
P.O. Box 4026, Clinton, MS 39058
601.925.3826   garrett@mc.edu   http://www.mc.edu/~garrett 

"The human race is divided into two sharply differentiated and
mutually antagonistic classes -- a small minority that plays with
ideas and is capable of taking them in, and a vast majority that
finds them painful, and is thus arrayed against them."
    -- H.L. Mencken


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