[Pugged] mysql

[Dave J. Hala Jr.]

I'm running mysql on RH8.0

I've got a table that has a field called AMT that is decimal(10,2) This
field currently has a value of -6500.00 If I do an update, no matter
what value I stick in here mysql makes it negative.

I did an insert and created and new record in this table, during that
insert I put the value 100 in the AMT field. Unfortunately it stores
that value as -100 

It seems like mysql has decided that EVERY value in this field in this
table should be negative no matter what. 

Anyone got any ideas?


-- 

"...Unix, MS-DOS and Windows NT (also known as the Good, the Bad, and
the Ugly)"

OSIS
Dave J. Hala Jr.
641.485.1606