What does this mean. All this code does is create a temp table. It is the same code that I have been using since 6.5++. With the latest update I get that error listed below. When I go back to an older update and it works just fine. Is this a bug that needs to be reported or has something changed and I need to do something different???
-ERROR- Item following the column name must be valid data type or expression (2779) Update file name RBG71_Update81_FRC6_07202005.exe Downloaded 07/21 at 10:00pm Pacific time CODE Some of the lines have been reformated by the email program --tEstHeader.TAB SET ERROR MESSAGE 2038 OFF DROP TAB tEstimateHeader SET ERROR MESSAGE 2038 ON CREATE TEMPORARY TABLE `tEstimateHeader` + (`EstimateID` INTEGER , + `EstimateVersion` INTEGER , + `EstimateNumber`= ((CTXT(EstimateID))+'-'+(CTXT(EstimateVersion))) TEXT (20) , + `EstimateDate` DATE , + `EstimateTime` TIME , + `CreditAppoved` INTEGER DEFAULT 2 , + `Flag` TEXT (1) , + `FlagMisc` INTEGER , + `CustID` TEXT (6) , + `CustName` TEXT (40) , + `SalesRepID` TEXT (6) , + `DateWanted` DATE , + `OrderStatusID` INTEGER , + `OrderTypeID` INTEGER , + `JobID` INTEGER , + `PlanID` INTEGER , + `LotNumb` TEXT (20) , + `CustPONumb` TEXT (20) , + `ContactID` INTEGER , + `CFirstName` TEXT (20) , + `CLastName` TEXT (20) , + `CPhone1` TEXT (14) , + `CPhone2` TEXT (14) , + `CPhone3` TEXT (14) , + `CPhone4` TEXT (14) , + `CEmail` TEXT (60) , + `Telephone1` TEXT (14) , + `Telephone2` TEXT (14) , + `CellPhone` TEXT (14) , + `Pager` TEXT (14) , + `FaxNumber` TEXT (14) , + `EMailAddress` TEXT (40) , + `ShippingAddress1` TEXT (30) , + `ShippingAddress2` TEXT (30) , + `ShippingCity` TEXT (20) , + `ShippingState` TEXT (2) , + `ShippingZipCode` TEXT (10) , + `ShippingCounty` TEXT (20) , + `ShippingCountry` TEXT (20) DEFAULT 'USA' , + `JobNotes` NOTE , + `Printed` TEXT (1) DEFAULT 'N' , + `DiscountID` INTEGER , + `DiscountAmount` REAL , + `CodDiscountAmount` REAL , + `MaterialDiscount` CURRENCY , + `SalesTax` REAL , + `EstimateSubTotal` CURRENCY , + `EstimateSalesTax` CURRENCY , + `EstimateTotal` CURRENCY , + `JobDiscountTotal`= (EstimateSubTotal- (EstimateSubTotal* DiscountAmount)) CURRENCY , + `DiscountTotal`= (EstimateSubTotal- (JobDiscountTotal+ MaterialDiscount))CURRENCY , + `SalesTaxTotal`= (DiscountTotal* SalesTax) CURRENCY , + `EstGrandTotal`= (DiscountTotal+ SalesTaxTotal) CURRENCY , + `ProcessedForGL` TEXT (1) , + `OrderShipDate` DATE , + `OrderShipped` TEXT (1) DEFAULT 'O' , + `MaterialPlanFlag` INTEGER , + `ChangeOrderLink` TEXT (20) , + `ChangeApproved` INTEGER , + `NotApprovedID` INTEGER , + `ReleaseDate` DATE , + `ManufactPartsFlag` TEXT (1) , + `PlanPriceSubTotal` CURRENCY , + `PlanPriceTax` = (PlanPriceSubTotal* SalesTax) CURRENCY DEFAULT (DiscountTotal* SalesTax) , + `PlanPriceTotal` = (PlanPriceSubTotal+ PlanPriceTax) CURRENCY , + `PlanPriceDiscount` = 1 - (PlanPriceSubTotal/ EstimateSubTotal) REAL , + `PlanPriceFlag` TEXT (1) , + `UnUsed1` TEXT (1) , + `UnUsed2` TEXT (1) , + `UnUsed3` TEXT (1) , + `UnUsed4` TEXT (1) , + `UnUsed5` TEXT (1) ) Victor Timmons Tiz's Door Sales, Inc 425-258-2391
