This was working for a few betas, but now it is not. make object! [ code: 329 type: 'script id: 'bad-bad arg1: "ODBC" arg2: "[ODBC Firebird Driver]Data truncated" arg3: none near: [insert db-port [{insert into "DIGITAL" ( patient, rdate, rtype, rvalue, comment, labid, runit ) values (?, ?, ?, ?, ?, ?, ?)} patient rdate rtype to-decimal rvalue comment labid runit] return reduce ] where: 'add-digitalresult ] When adding this baby information .... the above error occurs.
I just tried it with my version and it works fine with your data. What version of Firebird server are you using?
The problem with the weight is when I use lbs to kg converter ... 10 lbs translates to 4.54545454545455 kg. Too many decimals.