In previous versions when creating table from servoy, the default primary key field name could be edited. Now you could not do that. You have to edit the field name from external sql programs. This is a bit annoying. Is this intended?
All columns names are editable as long the table is not yet created, many databases do not support column rename at all (which means you have to remove and recreate the column with new name)
No Jan, that is not what faheemhameed is pointing out!
If you now create a new table within Servoy, the primary-key is not editable anymore! In prior version you could change the primary-key name and THAN hit the Apply button.
Now the Apply button is fired, when you create a table.
This also the case, when you copy tables within Servoy.
In prior version, you could make (minor) changes before you hit the apply button. Now it does not allow that anymore!
If I create a new table the pk column field name IS NOT editable in the latest version of Servoy (well, I can’t seem to do it) . It used to be until the latest update.
Also if I copy a table no column names are editable even though I have not yet pressed “apply” and “created” the table. This means that I can’t edit the pk column name even if I change the name of the table, therefore I have a pk name which is not the same as my table name. So, it basically means I can’t use table templates.
That’s what I said
Sorry, our posts crossed
We are unable to reproduce this, the name is editable as long you did not press “apply” or “ok”, also we did no change anything in there since Servoy 2.1.
I posted about this issue last Friday. A user called Morley responded to my post that he also had the same problem.
I will reconfirm that this is happening with me also !
Servoy Developer
Version R2 2.1.2-build 315
Java version 1.4.2-38 (Mac OS X)
- New Table
Go to Define Dataproviders
Click on Server
Click on New Table
Table is created BUT the ‘apply’ changes is fired instantly and you cannot modify the PK name !
- Copy Table
Go to Define Dataproviders
Click on Server
Click on Copy Table
Table is copied to new specified name BUT the ‘apply’ changes is fired instantly and you cannot modify any column name nor attributes !
Cheers
Harry