decimal and thousand separator

Forum related to MySQL

Moderators: gto, cipto_kh, EgonHugeist

Post Reply
fcodebue
Junior Boarder
Junior Boarder
Posts: 32
Joined: 05.04.2008, 16:02
Contact:

decimal and thousand separator

Post by fcodebue »

I have a field defined DECIMAL(18,6) with a default value 100.000000
When I append a new record, I set default value using component TZSQLMetadada and this code:

tabella_default := tzsqlmetadata.create(self);
tabella_default.tablename := tabella_tablename;
tabella_default.metadatatype := mdcolumns;
tabella_default.connection := tabella.connection;
tabella_default.open;

when I use this istruction my_table.fieldbyname('field_decimal').value := tabella_default.fieldbyname('column_def').value

zeos assign a 100000000 value instead 100.000000 (so use decimal separator and not thousand separator)

I use these code with firebird and postgres without problem
Codebue Fabio
P-Soft - http://www.p-soft.biz
Firebird La Comunità Italiana - http://www.firebirdsql.it
GestionaleOpen - http://www.gestionaleopen.org
Post Reply