SQL insert of unfilled fields

Hello All,

Wappler seems to be generating sql inserts with empty strings (’’) for unfilled numeric forms input fields instead of the NULL value.
This generates a conflict with mysql for numeric columns and causes an error - 1366 Incorrect decimal value – when executing insert statements.
Does anybody know a way to overcome this problem?
Thanks a lot for any help

Community Page
Last updated: