Record Locks in OpenVMS and QUIZ

[Mike.Lamers@phs.com]

Hello ..
We run PH vers 7.10G on Alpha Open VMS.
I'm having problems with record locks and QUIZ and QTP

In QTP I'm doing something like:
ACCESS RECORD_A LINK TO RECORD_B OPTIONAL

SELECT RECORD_A IF (TEST CONDITION)
SELECT RECORD_B IF (TEST CONDITION)
SELECT IF NOT RECORD_B EXISTS

SUBFILE ...

When validating the results, we found a few cases where record_a was
selected even though it appeared that record_b did exist.  The only
explanation seemed to be that record_b was locked by another process at the
time QTP encountered the record.  Rather than reading the locked record or
waiting for the record to be released, it appears that QTP skipped the
record.  One consultant suggested that this is a known problem with Quiz and
QTP.  I'm skeptical ... I prefer to believe that we're overlooking a SET
statement, but I've not been able to track that down.

Do Quiz and QTP deal with locked records the same way?

Is there a SET statement that will tell Quiz or QTP to read a locked record
or to wait until the record is free before proceeding?

Thanks for any help.

mike.lamers@phs.com




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