Announcement

Collapse
No announcement yet.

Invalid data, invalid size

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Invalid data, invalid size

    i have a field in the mysql datatype: decimal (3,1)
    in my form am trying to enter this data: 15.0
    when i click insert, i get the error: Invalid data, invalid size

    to isolate the cause, i went straight to the database and inserted the number 15.0. No errors

    yet doing the same in the form, i get that error!

  • #2
    It happened once for me, but don't remember. Check:
    SQL Type in field settings.
    Change field type to text and look into Allowed Characters.

    Sync your form against database.
    Try to recreate the form against same table to see if in new form it fails.
    /Giuseppe

    Professional Scriptcase Services
    Some Customers opinions

    Comment


    • #3
      Solved ...dont remember how

      Originally posted by Giu View Post
      It happened once for me, but don't remember. Check:
      SQL Type in field settings.
      Change field type to text and look into Allowed Characters.

      Sync your form against database.
      Try to recreate the form against same table to see if in new form it fails.
      I set the datatype to decimal and in the value format i set the minimum value to 3.0 (tho the decimal shouldnt matter)

      Comment

      Working...
      X