MySQL 5 Calculate Field query

2006-05-04 Thread Hendro Suryawan
Hi all, I found something strange with calculate field query in MySQL 5. My base table structure like this : CREATE TABLE `BrgIn2` ( `PO` varchar(17) NOT NULL default '', `BrgId` int(10) NOT NULL default '0', `Qty`

Re: MySQL 5 Calculate Field query

2006-05-04 Thread Dan Nelson
In the last episode (May 04), Hendro Suryawan said: Hi all, I found something strange with calculate field query in MySQL 5. My base table structure like this : CREATE TABLE `BrgIn2` ( `Qty` decimal(10,3) NOT NULL default '0.000', `Price`