RE: OPNQRYF - duplicate field name error

Why do you have an active x control attached to your Email?  This is EXACTLY why I do not like HTML email. 

Bob

-----Original Message-----
From: owner-midrange-l@midrange.com [mailto:owner-midrange-l@midrange.com]On Behalf Of David Prowak
Sent: Wednesday, June 14, 2000 5:13 PM
To: midrange list
Subject: OPNQRYF - duplicate field name error

Hi,

I'm using an Opnqryf to join 2 files and select some recs from the joined file.

The problem is that the field that I'm joining on has the same name in each file, so that I'm

getting a "field TICKET found in more than one record format" error.

I've tried renaming the field using MAPFLD, but I still get the same error.

How can I fix this?

Here's the code using the MAPFLD:

                                                          
 OPNQRYF    FILE((TRPTOPAY) (TRPMASTR)) FORMAT(TRPTOPAY) +
              QRYSLT('STATUS *EQ "5"') +                  
              JFLD((TRPTOPAY/TICK TRPMASTR/TICKET)) +     
              JDFTVAL(*NO) MAPFLD((TICK 'trptopay/ticket'))

Here's the one without my failed attempt with MAPFLD:

                                                            
  OPNQRYF    FILE((TRPTOPAY) (TRPMASTR)) FORMAT(TRPTOPAY) +
               QRYSLT('STATUS *EQ "5"') +                  
               JFLD((TRPTOPAY/TICKET TRPMASTR/TICKET)) +   
               JDFTVAL(*NO)                                

TIA,

Dave