Icon View Incident Report

Serious Serious
Reported By: Fernando Dias
Reported On: 6/27/2008
For: Version 2.00 Build 2
# 2691 ODBC Driver Causing Rouding Error When Opening Table in Access with Decimal Column

Opening the following table "Clientes" results in the following string in certain rows:

"#Erro" = "#Error"

and causes the following error:

"O arredondamento do valor decimal resultou na truncagem de dados"
=
"The decimal value rounding resulted in truncated data"

CREATE TABLE "Clientes"
(
"NumCliente" INTEGER,
"Nome" VARCHAR(55) COLLATE "PTG",
"IdFiscal" VARCHAR(9) COLLATE "PTG",
"CodMoeda" VARCHAR(3) COLLATE "PTG",
"Morada" VARCHAR(50) COLLATE "PTG",
"Localidade" VARCHAR(30) COLLATE "PTG",
"CodPostal" VARCHAR(39) COLLATE "PTG",
"Telefone" VARCHAR(30) COLLATE "PTG",
"Telemovel" VARCHAR(30) COLLATE "PTG",
"Fax" VARCHAR(30) COLLATE "PTG",
"Email" VARCHAR(50) COLLATE "PTG",
"CodActividade" VARCHAR(3) COLLATE "PTG",
"Contactos" VARCHAR(50) COLLATE "PTG",
"Grupo" VARCHAR(10) COLLATE "PTG",
"CodCondPaga" VARCHAR(3) COLLATE "PTG",
"CodVendedor" VARCHAR(3) COLLATE "PTG",
"Obs" VARCHAR(50) COLLATE "PTG",
"CodFornecedor" VARCHAR(8) COLLATE "PTG",
"PaginaWWW" VARCHAR(50) COLLATE "PTG",
"CriadoPor" VARCHAR(10) COLLATE "PTG",
"DataAlterado" DATE,
"AlteradoPor" VARCHAR(10) COLLATE "PTG",
"DataCriacao" DATE,
"ObsIdFiscal" VARCHAR(10) COLLATE "PTG",
"Situacao" VARCHAR(8) COLLATE "PTG",
"PctDesconto" DECIMAL(20,4),
"LimiteCred" DECIMAL(20,2),
"Saldo" DECIMAL(20,2),
"Zona" VARCHAR(20) COLLATE "PTG",
"Local" VARCHAR(20) COLLATE "PTG",
"CodPais" VARCHAR(2) COLLATE "PTG",
"PrefIdFiscal" VARCHAR(2) COLLATE "PTG",
CONSTRAINT "PrimaryKey" PRIMARY KEY ("NumCliente")
)



Comments Comments
The ElevateDB engine was returning incorrect scale information for DECIMAL/NUMERIC columns to the application. This only affected certain rows that actually had data in the DECIMAL column for the table.


Resolution Resolution
Fixed Problem on 6/29/2008 in version 2.01 build 1


Products Affected Products Affected
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial

Image