Bizarre QTP problem

[John MacLerran]

Hello Everyone,

I'm having a problem where QTP isn't working as I expect. Consider the
two requests below:
;--------------------------------------------------------------
request GET-UNIQUE-VENDORS
;
;  Get unique vendor numbers from subfile. Make sure they
;  don't already exist in the Vendor Master Dataset.
;
acc *BIINVFL link AI-VEN-NBR to AI-VENDOR-NBR of  &
          AI-VENDOR-M optional
select if not record AI-VENDOR-M exists
sort on AI-VEN-NBR
subfile BIINVFL2 keep at AI-VEN-NBR include BIINVFL
;---------------------
;   Put the vendors identified above into the master dataset
;
request ADD-VENDOR-M
;
access *BIINVFL2
sorted on AI-VEN-NBR
;
output AI-VENDOR-M add at start of AI-VEN-NBR
     item AI-VENDOR-NBR initial AI-VEN-NBR
     item AI-VENDOR-IND final   "    "
;---------------------------------------------------------

Fairly straightforward, Right? But, when I run the above code, I get the
following messages

Executing request GET-UNIQUE-VENDORS ...
Records read:
  BIINVFL                                223
  AI-VENDOR-M                       46
Transactions processed:                36
Records processed:                     Added    Updated  Unchanged
Deleted
  BIINVFL2                                 9          0
0          0
((( 9 vendors in the subfile that don't exist in the master file. Ok, so
far.)))

Executing request ADD-VENDOR-M ...
------------------------------------------------------------
Data access
error.                                                         [1]
   File:  AI-VENDOR-M
     Linkitem:  AI-VENDOR-NBR
Action Taken: Run terminated.
------------------------------------------------------------
Attempt to add a duplicate value when UNIQUE KEY/INDEX was specified.
   File:  AI-VENDOR-M
     Linkitem:  AI-VENDOR-NBR
------------------------------------------------------------

Why am I getting this? How can the value be a duplicate when the first
run did a 'select if not record exists' construct?  I've checked the
subfile, and the 9 records it finds are indeed not in the database, and,
using the same login as the qtp that runs this process, I can add the
records manually, using a quick screen, to the same dataset, so I know
that PDL and Image security are ok.

I've tried several permutations of the above requests, including: using
only 1 request with optional linkages and select if not record exists
constructs: using output add update constructs: moving the sort
statement around. I've even tried PH819C2 and the Qtp Tracer, with no
difference in output. QTP Tracer didn't show anything except the same
error messages.

What am I doing wrong?

(Platform: HP3000, TurboImage, PH729C5 & PH819C2)
----------------------------------------------------------------------
  John MacLerran
  IT Systems Analyst                       email:   macljohn@isu.edu
  Idaho State University                             V(208) 236-2872
  http://www.isu.edu/~macljohn                       F(208) 236-3673
----------------------------------------------------------------------


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