I introduced this computed by column in ReceiptLine Table. The column is
basically Numeric(15,4).
Here is the column code,
ALTER TABLE RECEIPTLINE
ADD AMOUNT COMPUTED BY (QUANTITY * PRICE -
(SELECT COALESCE(SUM(DISCOUNT),0)
FROM RECEIPTDISCOUNT
WHERE RECEIPTDISCOUNT.RECEIPTLINEID = ID));
But when imported into edmx the column data type is imported as Int64.
Every time I when I rerun the edmx file, have to manually change the data
type.
Except this computed by column, the rest of the numeric(15,4) types is
interpreted correctly as decimal.
Any help Is highly appreciated.
Thanks!
Muthu Annamalai
------------------------------------------------------------------------------
RSA(R) Conference 2012
Mar 27 - Feb 2
Save $400 by Jan. 27
Register now!
http://p.sf.net/sfu/rsa-sfdev2dev2
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
