[RBG7-L] - Re: Error 2779

[MikeB]

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" <rbg7-l@rbase.com>
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
>