REMINDER
Please be respectful of all AppDragers! Keep it really civil so that we can make the AppDrag community of builders as embracing, positive and inspiring as possible.
Bug: Updating company columns when time field exists
-
Hello team,
Bug:
When adding a column to a table with a time field that has an existing default value, the alteration fails.Expected behavior:
It should work
Problem:
When rendering the default value for the time field, the number is formatted for humans. I.e. 110000 becomes 11:00:00 in the UI.However, when altering the table, your code is performing an UPDATE query that tries to set 11:00:00 as the default value for a TIME type column, which fails.
Workaround:
Manually editing 11:00:00 to 110000 before saving your changes to the table causes the update to succeed.
