Victor, Something in this section doesn't look right to me. As you said it may have been the email program. > `PlanPriceTax` = (PlanPriceSubTotal* SalesTax) CURRENCY DEFAULT > (DiscountTotal* SalesTax) , + > `PlanPriceTotal` = (PlanPriceSubTotal+ PlanPriceTax) CURRENCY , +
This is not an answer, just an attempt to locate the problem line(s). Strip out the computed column lines and see if it works. If it does, add the computed ones back in until it fails. Jan ----- Original Message ----- From: "Victor Timmons" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Friday, July 22, 2005 8:10 AM Subject: [RBG7-L] - Error 2779 > 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 > >
