0 Decimal

Hi

I am getting this error on decimal setup in preference. When I set any of the four decimal to "0" and save, it saves without any error. What system is doing is it is saving as the field as blank. When I go back to preference page the field which I had set to "0" is blank. Now after changes to any other parameter on this page, when I save, it give this error. You have to again key in "0" where you have "0" decimals to save the settings.

DATABASE ERROR :
At file C:\www\fa\admin\db\users_db.inc:65:
could not update user display prefs for 1
error code : 1366
error message : Incorrect integer value: '' for column 'qty_dec' at row 1
sql that failed was : UPDATE 0_users SET prices_dec='2',qty_dec='',rates_dec='4',percent_dec='2',date_format='1',date_sep='0',tho_sep='0',dec_sep='0',print_profile='',theme='cool',page_size='A4',language='C',startup_tab='orders',show_gl='1',show_codes='1',show_hints='1',rep_popup='1',graphic_links='1',sticky_doc_date='1',query_size='125' WHERE id='1'

Thanks