<![CDATA[FrontAccounting forum — 0 Decimal]]> 2014-03-12T13:11:26Z PunBB https://frontaccounting.com/punbb/viewtopic.php?id=4794 <![CDATA[Re: 0 Decimal]]> Hi Joe

It works

Many thanks

]]> https://frontaccounting.com/punbb/profile.php?id=16332 2014-03-12T13:11:26Z https://frontaccounting.com/punbb/viewtopic.php?pid=19471#p19471 <![CDATA[Re: 0 Decimal]]> This has now been fixed and sent to the HG repository. Please go here and download this file (link up left).

Replace the file in the /admin folder.

/Joe

]]> https://frontaccounting.com/punbb/profile.php?id=3 2014-03-11T23:12:40Z https://frontaccounting.com/punbb/viewtopic.php?pid=19470#p19470 <![CDATA[Re: 0 Decimal]]> Thanks dvarsani. I will have a look at this.

Joe

]]> https://frontaccounting.com/punbb/profile.php?id=3 2014-03-11T08:56:12Z https://frontaccounting.com/punbb/viewtopic.php?pid=19468#p19468 <![CDATA[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

]]> https://frontaccounting.com/punbb/profile.php?id=16332 2014-03-11T08:12:24Z https://frontaccounting.com/punbb/viewtopic.php?pid=19467#p19467