[Firebird-odbc-devel] Problems with Firebird and DataTypes... (Numeric and ftBCD)

[Kurt S. <kj...@gm...>]

Hello
 (Sorry for my English)
  But, i=B4have the following problem:
 In my Firebird (V 1.5.2.4731) DataBase i have fields with DataType
Numeric(18,6) and Numeric(12,6). I=B4m use ADO + ODBCJDBC
(ODBC_2.0.0-Win32_Date 25_02_2005) connection to acessing the Firebird
Server, and ADOQuery for data acessing (insert, update, delete)
 some fields on database ha the following values :
Order Vlr
1 0,352889
2 0,352888
  Whel, when testing and sql in Firebird GUI (IBExpert or Sql Hammer) the
return is the samen value stored in database field
 Order Vlr
1 0,352889
2 0,352888
 But when the same testing is execute from Delphi (v 7.0) the result is
 Order Vlr
1 0,3528
2 0,3528 and the Field dataType is FtBCD
 Two decimal digitos had been lost and the FTBCD dataType suport only
precision =3D 4;
 Question:
 1) The problem this in the ODBC? New Version resolves?
 2) The problem this in the Firebird Database? New Version resolves?
 3) The Problem this in the ADO?
 One solutions is in the SQL instructions convert whit cast the numeric
field to FLOAT, and use a function to truncate or to round, but i=B4m thing
this is not the best method.
 Help, this is very important.
 Thanks

***************************************************************************=
*********
Kurt Schneider - [ Analista de Sistema ]
Especialista em Analise e Desenvolvimento de Software
ControlSoft - Assessoria e Desenvolvimento de Sistemas
e-mail: kj...@gm...
"Quis custodiet ipsos custodes?" - Satir=E1s - De Juvenal