Victor, Perhaps because the computation always occurs there is never a need to activate a default value.
Jim Bentley --- Victor Timmons <[EMAIL PROTECTED]> wrote: > 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 > === message truncated === Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
