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!
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.
Solved …dont remember how
[QUOTE=Giu;41482]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.[/QUOTE]
I set the datatype to decimal and in the value format i set the minimum value to 3.0 (tho the decimal shouldnt matter)
same problem here
any workarounds other than re-creating form ?