Can't add Baby information - weight, height, HC

Discussion in 'Bugs & Issues' started by Jason, May 6, 2009.

  1. Jason

    Jason Developer / Handyman Staff Member

    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.

    Attached Files:

  2. Jason

    Jason Developer / Handyman Staff Member

    I can add HC and Height with decimals, but Weight cannot have a decimal.
  3. Graham

    Graham Developer Staff Member

    try with one decimal point ... it may be numeric overflow.

  4. Graham

    Graham Developer Staff Member

    I just tried it with my version and it works fine with your data.

    What version of Firebird server are you using?
  5. Jason

    Jason Developer / Handyman Staff Member

    The problem with the weight is when I use lbs to kg converter ...

    10 lbs translates to 4.54545454545455 kg.

    Too many decimals.

Share This Page