Decimal field

[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.

[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