HELP!  I'm trying to run a QTP conversion process that keeps reporting
data conversion errors.  The problem is, I don't know how to tell QTP
to report any meaningfull information so I can tell what records are
causing the problem.  Here is the code:
 
;FILE MTLFIXQ.DB - Removes extraneous records in MATERIAL and updates JOB-HEADER
 
REQUEST DELETE
 
ACCESS MATERIAL LINK KEY TO JOB-HEADER
 
SET REPORT ERRORS
SET PROCESS LIMIT 2000000
 
SELECT IF DATE8 < DT-RECEIVED[1:8] OR DT-ACCEPTED < DATE8
 
OUTPUT MATERIAL DELETE
 
GO
 
REQUEST UPDATE ON CALCULATION ERRORS REPORT
 
ACCESS MATERIAL LINK KEY TO JOB-HEADER
 
SET PROCESS LIMIT 2000000
SET REPORT ERRORS
 
DEFINE EXTENDED-COST INT*4 = ROUND(QUANTITY * COST-MATERIAL)
 
SORT ON KEY OF JOB-HEADER
 
OUTPUT JOB-HEADER UPDATE
 
ITEM TTL-COST-MTL SUBTOTAL EXTENDED-COST RESET AT KEY
 
GO
 
The problem ocurrs with EXTENDED-COST.  QUANTITY is an I2 with one
assumed decimal place.  COST-MATERIAL is an I2 with three assumed
decimal places.  Is there any way to find out what data is causing
the problem?
 
For those of you seeing this on the PowerHouse list, please respond
to me as I am not a subscriber.
 
TIA,
 
 
 
 
 
 
 
 
I know the thoughts expressed here are my own because no one else would claim
them!
 
Don Harrington                      [log in to unmask]
Boeing Commercial Airplane Group    Phone:   206-931-4457
PO Box 3707  MS 5J-34               FAX:     206-931-2325
Seattle, WA  98124-2207