----- Original Message ----- From: "Vassilopulos, Georg" <geo...@yormas.de> To: "Jorge Bastos" <mysq...@decimal.pt> Sent: Friday, October 07, 2005 2:19 PM Subject: AW: UPDATE does round value automatically - is it an error?

Table structure is here. Thank You!!

Field Type Null Key Default Extra datum date (null) PRI 2004-00-00 (null) closed_f tinyint(1) YES (null) 0 (null) closed_s tinyint(1) YES (null) 0 (null) umsatz_1_f float YES (null) 0 (null) umsatz_2_f float YES (null) 0 (null) umsatz_3_f float YES (null) 0 (null) umsatz_4_f float YES (null) 0 (null) umsatz_5_f float YES (null) 0 (null) kasse_f float YES (null) 0 (null) umsatz_1_s float YES (null) 0 (null) umsatz_2_s float YES (null) 0 (null) umsatz_3_s float YES (null) 0 (null) umsatz_4_s float YES (null) 0 (null) umsatz_5_s float YES (null) 0 (null) kasse_s float YES (null) 0 (null) differenz_f float YES (null) 0 (null) differenz_s float YES (null) 0 (null) safebag_f bigint(20) YES (null) 0 (null) safebag_s bigint(20) YES (null) 0 (null) ausgaben_f longtext YES (null) (null) ausgaben_s longtext YES (null) (null) wetter_f text YES (null) (null) wetter_s text YES (null) (null) timestamp_f timestamp YES (null) CURRENT_TIMESTAMP (null) timestamp_s timestamp YES (null) 0000-00-00 00:00:00 (null) benutzer_f varchar(30) YES (null) (null) (null) benutzer_s varchar(30) YES (null) (null) (null) ezk_f tinyint(1) YES (null) 0 (null) ezk_s tinyint(1) YES (null) 0 (null) custom_varchar_f varchar(30) YES (null) (null) (null) custom_varchar_s varchar(30) YES (null) (null) (null) custom_text_f longtext YES (null) (null) custom_text_s longtext YES (null) (null) custom_float_f float YES (null) 0 (null) custom_float_s float YES (null) 0 (null)