Page 1 of 1

Decimal field

Posted: 18.08.2010, 14:43
by Mary
I have a table with decimal field in MySQL database.

Code: Select all

create table Products(
	Id int not null primary key,
	ProductName varchar(100) not null,
	Price decimal(15,2)
);
MySQL server version is 5.0.32.

I use Delphi7 and in the ZTable1 the type of the field Price is TFloatField. Can I write a proper value of the field Price into currency variable?

Zeos library version is 6.6.6.

Posted: 15.02.2012, 13:17
by mparak
Hi Mary,
Do you wish to write the formatted value to the table, or read it from the table into a @variable?
Let me know which,
Both are easy.
Mo