I think it could be helpful to have a preference pane where you can have some database dependet settings. For example, I’d like to see a “Maximum column name length”, where I could enter for example 30 to make sure that certain databases can handle the name properly. This setting would then checked when adding a new column.
Another property could be the default naming of sequences, as I have already asked for in another thread. I am sure that there will be more useful settings…
When you use more then one brand of (O)RDBMS then you need to have multiple instances of those settings (profiles?).
Also you then need to assign those profiles to your DBServer settings.
You could ask yourself if all this belongs in Servoy. Since for serious data-modeling you use other tools.
About naming conventions of sequences. I was hoping the JDBC driver would be able to provide such info from the database.
I am more in a situation where I develop always on the same database but deploy on all kinds of systems. So I have only on profile of DB settings. But I want to have some common ground for all major DBs…
found another one for the pref panel: default fields for a table. In general I have a created, created by, changed, change by and so forth column in a table. Now I have to type all those by hand every time I create a table.
I know that feeling of having to type is all by hand everything, making mistakes in the proces and spending quite some time figuring out why something isn’t working as it should…
So, when I do major tablecreation, I do not use Servoy, but a proper DB Management tool.
Else, I try to use the following workaround: copy table. I just have a dummy table with all the fields i want to have on every table and use that as a table template.