Your parameter is DECIMAL(18,2). If you want scale 2, specify that.
Mark
----- Reply message -----
Van: "Muthu Annamalai" <pearlamer...@hotmail.com>
Aan: <firebird-net-provider@lists.sourceforge.net>
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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
------------------------------------------------------------------------------
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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider