|
From: Kurt S. <kj...@gm...> - 2005-09-27 20:27:33
|
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 |