I'm running into a problem in QV v.8 on a doc that's been working for years pulling data from QVD files...all of a sudden the scripts fails on ALL of the load statements utlizing the QVD files. I've moved the order, commented out, everything i know to try and figure out the exact problem. I can cut the load statements from this doc into a new qvw doc and run it and the qvd load fine with no errors. Even restored the doc from a couple of weeks ago...same load failure.
Obviously a little frustrating....any ideas? Here's just one of the 8 different load statements that's failing...and as i said..the doc had been working for years and just cratered about 3 weeks ago for no apparent reason.. I included the preceeding load statement that executes correctly prior to the Field not found (and it's alwasy the first field in the load statement..regardless of my changing the field order..
CallCategories:
Load * INLINE [
CallCategory, CategoryDesc, CategoryOrder
CM, Corrective Maintenance, 0
PM, Preventative Maintenance, 1
CC, Courtesy, 2
IR, Install/Delivery, 3
SH, Shop, 4
PF, PhoneFix, 5
O, Other, 6 ] ;
Reports:
LOAD
ReportID,
ReportID as ReportLaborID,
CallNumber,
BillCodeID,
CallID,
CallID as SurveyCallID,
UnAvailableHours,
UnAvailableDay,
LocationName,
LocationAddress,
LocationCity,
LocationZip,
MasterCallID,
CallInvoiceNumber
From
SCREPORTS.QVD (QVD);
