I have many columns defined in my MySQL 5.0 database with default values, however Servoy 4 does not seem to be honoring them whereas 3.5+ did. All of the data providers in serovy 3 that HAD ‘Database Default’ set for their auto-enter value have now gone to “System Value: None”.
When change a data provider to be ‘Database Default’, do Apple-S to save (there is no ‘Apply’/‘Ok’ button?!?!), close the table tab and come back to the table it has switched itself back to “System Value: None”.
Something I just noticed…
When I go though each table and try setting the “database default” auto-enter value, servoy creates a datasources->solution name->tablename.obj file for each table that i attempt to fix (although I cant fix it) in my Resources Project that the solution uses. The ‘datasources’ folder, sub-folders and .obj files where not there previously (svn says so), so it looks like it got created with the first table i tried to fix.
Also while looking at the table in the form design perspective, each time I select a colum my computer gives me a ‘warning’ beep, but no dialog box saying why its beeping at me.
I just went back into a table to try fixing the database defaults again after rebooting and now I get the attached message, and there is nothing in the “problems” tab about this table.
We identified the bug related to database default option, it is fixed now and will be included in next release. It is only a user interface problem, so the user interface does not adjust according to column values, in this case.