Re: [Firebird-net-provider] Scale Precision 4 Truncates to 2 in Database

[<ma...@la...>]

Your parameter is DECIMAL(18,2). If you want scale 2, specify that.
Mark

----- Reply message -----
Van: "Muthu Annamalai" <pea...@ho...>
Aan: <fir...@li...>
Onderwerp: [Firebird-net-provider] Scale Precision 4 Truncates to 2 in Database
Datum: zo, jul. 6, 2014 00:46

Hi,
I am using Provider 4.2.0.0 and EF 6.0.0.0 in VS 2012. 
When I update a value with 4 digit precision as 1.9999, the value in
database is saved as 1.99. The last 2 digits got truncated. 
I really want 4 digit precision. Any help is appreciated.

In database table the field is set to a domain, which is

CREATE DOMAIN DECIMAL4 AS
NUMERIC(15,4)
DEFAULT 0
NOT NULL;

On submit changes from Visual Studio , the output from the provider is

FirebirdSql.Data.FirebirdClient Information: 0 : Command:
EXECUTE BLOCK (
p0 DECIMAL(18,2) = @p0, p1 INT = @p1
) RETURNS (
"DESCRIPTION" BLOB SUB_TYPE TEXT)
AS BEGIN
UPDATE "ITEMSTYLE"
SET "PRICE" = :p0
WHERE ("ID" = :p1)
RETURNING "DESCRIPTION" INTO :"DESCRIPTION";
SUSPEND;
END

Parameters:
Name:@p0 Type:Decimal Used Value:1.9999
Name:@p1 Type:Integer Used Value:19191

Thanks,
Annam

------------------------------------------------------------------------------
Open source business process management suite built on Java and Eclipse
Turn processes into business applications with Bonita BPM Community Edition
Quickly connect people, data, and systems into organized workflows
Winner of BOSSIE, CODIE, OW2 and Gartner awards
http://p.sf.net/sfu/Bonitasoft
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider