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
