SC6
I have made some changes to the table structure (MySQL).
Edited manually SELECT… structure for the GRID but the fields in
Edit Fields
Fields Positioning
still show the old structure and old names!
I even tried to create new dictionary from the database, but it did not help.
How can I update it to show current state/structure
Arthur
How to upgrade fields list
[QUOTE=aka;14099]SC6
I have made some changes to the table structure (MySQL).
Edited manually SELECT… structure for the GRID but the fields in
Edit Fields
Fields Positioning
still show the old structure and old names!
I even tried to create new dictionary from the database, but it did not help.
How can I update it to show current state/structure
Arthur[/QUOTE]
Hi, I’ve just had exactly the same problem as you did, so I’ve asked the help desk for assistance.
In order to update the fields of an application that you have created before any changes you’ve performed to the associated table’s structure, open your application, go to the application menu at the left panel of your working area and select Sychronize table. This will do it for you.
Hope this solves your problem.
That will work for forms only. For grids, you need to change the sql statement manually. After saving the SQL the fields will appear.
I changed SQl but field list did not change. Could it be because it is the primary key?
go to edit fields. There your new fields will be, but out of the form scope. Move them to the correct location.