Indexes

[velvettiger]

Hi Guys,

When I run the below query I am getting the following message being output in my text documents.

MESSAGE
Field 22 from customer record (recid 80255026) was missing from field phrase.

OUTPUT TO C:\cal\ALLTRANSACTIONSEXCEPTSC_TUESINDEXS.TXT.
SESSION:DATE-FORMAT = "ymd".
FOR EACH customer FIELDS (customer.card-no)
     NO-LOCK:
    FOR EACH tranfile FIELDS(tranfile.issue-no tranfile.tran-date tranfile.subsidiary-id tranfile.card-no tranfile.tran-points tranfile.on-statement )
           
          WHERE tranfile.customer-id = customer.customer-id
                AND tranfile.card-no = customer.card-no
                AND tranfile.issue-no > 0
            USE-INDEX tranfile-idx
        
     NO-LOCK:
    

        
       
EXPORT 
    DELIMITER ","
    
    customer.card-no
    tranfile.subsidiary-id 
    string(tranfile.tran-date, '9999/99/99')
    tranfile.tran-points 
    tranfile.on-statement 
    tranfile.issue-no
    . 
    
     
   
END.
 
END.

OUTPUT CLOSE.

 

[TomBascom]

What does this have to do with indexes?

FWIW you are obviously referring to fields which are not in the FIELDS phrase. Customer.customer-id is a pretty obvious example. So the error is hardly surprising.