[Firebird-net-provider] Scale Precision 4 Truncates to 2 in Database
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., 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:@p0Type:DecimalUsed Value:1. Name:@p1Type:IntegerUsed 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
Re: [Firebird-net-provider] Scale Precision 4 Truncates to 2 in Database
Your parameter is DECIMAL(18,2). If you want scale 2, specify that. Mark - Reply message - Van: "Muthu Annamalai" Aan: 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., 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. 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
Re: [Firebird-net-provider] Scale Precision 4 Truncates to 2 in Database
On 6-7-2014 01:14, m...@lawinegevaar.nl wrote: > Your parameter is DECIMAL(18,2). If you want scale 2, specify that. That should of course have read "If you want scale 4, specify that". Mark -- Mark Rotteveel -- 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