Record Locks in OpenVMS and QUIZ

[Chris Sharman]

>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

If record A fails the test, it's discarded.
Similarly, if record B fails, it's discarded, but B is optional, so the record
complex is kept.
So "select if not record b exists" actually means select if no record b is
selected". Don't know if that's what you're seeing.
>
>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?

Qtp by default locks, & waits for the lock if necessary.
Quiz doesn't lock.
I think you're right to be sceptical of your consultant - I'd say he's lying or
guessing.

>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?

Yes, you can set locking options for qtp.

Chris
_______________________________________________________________________
Chris.Sharman@CCAgroup.co.uk		http://www.ccagroup.co.uk/
CCA Stationery Ltd, Eastway, Fulwood, Preston, Lancashire, PR2 9WS.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.