WP Data Access Double Field don’t accept decimal input

  • Resolved martinloehr

    (@martinloehr)


    9 months ago

    Hi,

    Using WP Data Access Plugin Basic for test.
    Because I don’t got a confirmation about the BUG Information to your APP form field usage, I will repeat the
    Info:

    Based on a MySQL database which contains decimal (Double) field definitions, your AppBuilder creates the correct double fields, but has the bug that I can not fill in a double value (decimals behind the comma are ignored).
    Thats a critical bug which makes your Plugin for reliable Number Data useless!

    After editing the wrong input double values in a third party SQL Manager the Double fields now showing up the decimals.

    Means:

    1. trying to use your plugin for new data input (no default data predefined, empty field) – no input function, only integer accepted
    2. trying to edit existing data (without decimal comma and decimal value) – no input function, after comma (.) no input possible, only integer accepted
    3. trying to edit existing decimal data with min. 1 decimal after comma (f.e. “23.5”)- input function ok

    Please eliminate this bug immediatly, otherwise your plugin is (until its done) completely useless.

    Thanks for understanding
    Martin

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter martinloehr

    (@martinloehr)

    9 months ago

    Additional Information 07-09-2025

    The Plugin changes after restart the complete correct data in the database and ignores the double defined comma.
    As result all data has to be edited or restored … thats inctredibel bad …

    For now this plugin is to call as damaging and dangerous useless

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    9 months ago

    Hi Martin,

    Sorry you’re having this issue. Your double column probably has no precision and scale. Please make sure to define the precision and scale. For example:

    column_name double // has no scale support in the App Builder
    column_name double(7,2) // has scale support in the App Builder

    If you have a support request, please be patient and do not post your message on four different channels. Thank you for your understanding.

    Best regards,
    Peter

    Thread Starter martinloehr

    (@martinloehr)

    9 months ago

    Thanks Peter,

    that was very helpful and solved my headaches (I am not an sql specialist).

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘WP Data Access Double Field don’t accept decimal input’ is closed to new replies.