Thank you. Maybe it was a bug and now its fixed. :-)
On 22 Jul 2005 at 10:25, MikeB wrote: > Victor, > The Column "PlanPriceDiscount" has an improperly formed expression.. > enclose > the whole expression in parens like: > > `PlanPriceDiscount` = (1 - (PlanPriceSubTotal/ EstimateSubTotal)) REAL, + > > > ----- Original Message ----- > From: "Victor Timmons" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[email protected]> > Sent: Friday, July 22, 2005 10: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
