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
decimal and thousand separator
Moderators: gto, cipto_kh, EgonHugeist
decimal and thousand separator
Codebue Fabio
P-Soft - http://www.p-soft.biz
Firebird La Comunità Italiana - http://www.firebirdsql.it
GestionaleOpen - http://www.gestionaleopen.org
P-Soft - http://www.p-soft.biz
Firebird La Comunità Italiana - http://www.firebirdsql.it
GestionaleOpen - http://www.gestionaleopen.org