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:[email protected]]
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
<[email protected]> 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
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
