Quick Screen Index Retrieval Mystery

Nancy Tietz ntietz@mcare3.med.umich.edu
Tue, 13 Apr 1999 09:56:36 -0400


Can you try DEBUG ?  I like to use it for mysteries.
nt

-----Original Message-----
From: Jayson Garrett [mailto:Garrett@mc.edu]
Sent: Monday, April 12, 1999 3: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.