Decimal field

Forum related to MySQL

Moderators: gto, cipto_kh, EgonHugeist

Mary
Fresh Boarder
Fresh Boarder
Posts: 1
Joined: 18.08.2010, 14:00

Decimal field

Postby Mary » 18.08.2010, 14:43

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
Senior Boarder
Senior Boarder
Posts: 81
Joined: 12.09.2005, 06:51
Location: Durban South Africa
Contact:

Postby mparak » 15.02.2012, 13:17

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
Mohammed Parak
CAD RETAIL
Durban South Africa
http://www.cad.co.za


Return to “MySQL”

Who is online

Users browsing this forum: No registered users and 1 guest