Re: [Firebird-net-provider] Computedby Column Edmx Issue

[Muthu A. <mut...@sb...>]

Here is the DDL for the table. In this table the column QUANTITY and PRICE,
which are Decimal4 (Numeric(15,4) domain that I created interpreted
correctly). The last column (AMOUNT), which is a computedby column is
interpreted as Int64


CREATE TABLE RECEIPTLINE (
    ID           INTEGER NOT NULL,
    RECEIPTID    INTEGER NOT NULL,
    ITEMSTYLEID  INTEGER,
    QUANTITY     DECIMAL4 NOT NULL /* DECIMAL4 = NUMERIC(15,4) DEFAULT 0 NOT
NULL */,
    PRICE        DECIMAL4 NOT NULL /* DECIMAL4 = NUMERIC(15,4) DEFAULT 0 NOT
NULL */,
    TAXABLE      SMALLINT NOT NULL,
    AMOUNT       COMPUTED BY (QUANTITY * PRICE -
(SELECT COALESCE(SUM(DISCOUNT),0)
 FROM RECEIPTDISCOUNT
 WHERE RECEIPTDISCOUNT.RECEIPTLINEID = ID))
);

-----Original Message-----
From: Jiri Cincura [mailto:di...@ci...] 
Sent: Tuesday, January 17, 2012 9:50 AM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Computedby Column Edmx Issue

On Tue, Jan 17, 2012 at 4:00 PM, Muthu Annamalai
<mut...@sb...> wrote:
> The datatype of other columns that is showing properly is Numeric(15,4).
The
> datatype of the computedby column is Numeric(15,8). I thought the decimal
> digits might be a problem, I created a numeric(15,4) domain and used that
in
> the computedby column, but still no luck...
> Thanks!

Provide a DDL for that table.

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

----------------------------------------------------------------------------
--
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider