Hi Everybody,
I have a program developed with Delphi7. I connect to SapDB with ODBC driver. My server is on a FreeBSD server. Version is 7.4.3.27.
In my tables some floating point values are not correct. Problem is that, I insert integer values, In SQL Studio I find floating point values. One example is: "894.999999999999" This number should be "895" Another example is: "10.0000000000011" and this number should be "10".
My table is created with below statement: CREATE TABLE "OZLER"."AVCILAR_SU_TUKETIMI" ( "TARIH" Date NOT NULL DEFAULT DATE, "OKUNAN_DEGER" Float (20) NOT NULL, "GUNLUK_TUKETIM" Float (20), PRIMARY KEY ("TARIH"), CONSTRAINT "CONSTRAINT1" CHECK "(OKUNAN_DEGER " > 0) )
In my program, I used ADOTables and DBEdit fields to be able to insert data in the table.
My ODBC driver version is: 7.4.3.00, SQLOD32.DLL, 26 February 2004.
Is there anybody who has an idea about the problem?
Thank you.
-- Ertan Küçükoğlu [EMAIL PROTECTED] Ozler Plastik San. ve Tic. A.S. Tel: +90.212.676.6767 Fax: +90.212.676.8012
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
