Mike: Thats kind of what I meant by my comment. Have a good day :)
On 22 Jul 2005 at 10:57, MikeB wrote: > It's not a bug. It's just that as RBase continues to be tweaked and > polished, > it is less forgiving of minor errors like the aforementioned. > > > > > ----- Original Message ----- > From: "Victor Timmons" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[email protected]> > Sent: Friday, July 22, 2005 10:35 AM > Subject: [RBG7-L] - Re: Error 2779 > > > > 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 > > > > Victor Timmons Tiz's Door Sales, Inc 425-258-2391
