From: Muthu A. <pea...@ho...> - 2014-07-05 22:46:14
|
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 |