I had tested it by first removing the email client wraps and corrected the expression for the "PlanPriceDiscount" column and the table created without error...
----- Original Message ----- From: "Victor Timmons" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Friday, July 22, 2005 12:05 PM Subject: [RBG7-L] - Re: Error 2779 > Your right on that one to. I need to look into that. > Thank You > Have a good day > > > On 22 Jul 2005 at 8:48, Jan Johansen wrote: > >> 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 >> > >> > >> >> > > > > Victor Timmons > Tiz's Door Sales, Inc > 425-258-2391 >
