Cannot add double values

  • Resolved tvdsluijs

    (@tvdsluijs)


    7 months ago

    I like the plugin a lot, but it seems there is quite a bug in the plugin.

    When I try to add a value to a table row where the field is DOUBLE I cannot add a decimal value.

    SO

    4.132231405

    or

    4,132231405

    Both jump automaticly to

    4132231405

    SO without the decimal. This is a real problem for me as I need to add decimal values.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter tvdsluijs

    (@tvdsluijs)

    It seems this is only with new rows

    Plugin Contributor Kim L

    (@kimmyx)

    Hi @tvdsluijs,

    Thanks for the post and sorry to hear you’re encountering issues.

    Can you try modifying the column’s data type into decimal(p,s) format where p = the total number of digits in the value, and s = number of digits after the decimal point?

    Example: decimal(7,3)

    See here:?https://share.zight.com/7KuXAXOL

    You can alter a table by going to WP Data Access > Data Explorer > select your table > Manage > Alter.

    Hope this helps! Let us know how it goes. ??

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Cannot add double values’ is closed to new replies.