James: Im not sure why this has never came up before. This file has never errored out before so I have not looked at it in years. I will be correcting it.
On 22 Jul 2005 at 11:28, James Bentley wrote: > Victor and all on the list. > I am curious about the following column definition: > > `PlanPriceTax` = (PlanPriceSubTotal* SalesTax) + > CURRENCY DEFAULT (DiscountTotal * SalesTax) , > > Is it valid syntax to have an expression as a DEFAULT. > WWW.RSYNTAX.COM shows only a choice of USER or NULL or > <value> and to the best of my knowledge <value> must > be a constant. > > Also, it would seem to me that since the column is a > computed column having a DEFAULT value would be an > invalid option. > > Jim Bentley > American Celiac Society > --- Jan Johansen <[EMAIL PROTECTED]> 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 > > > > > > > > > > > > > Jim Bentley > American Celiac Society > [EMAIL PROTECTED] > tel: 1-504-737-3293 > > > > ____________________________________________________ > Start your day with Yahoo! - make it your home page > http://www.yahoo.com/r/hs > > > Victor Timmons Tiz's Door Sales, Inc 425-258-2391
