database Truncate error

[eluser]reghan[/eluser]
Thanks for the reply.

I have set the money column to

null = no
default = as defined: 0.00

and it still gives me the truncate error:

Error Number: 1265

Data truncated for column 'Day1_LostRevenue' at row 1
for the column that I have set the default to 0.00.

SO I am really unsure what the problem says. I totally agree with your answers, but its just not working.