If the name of a table is changed in MySQL, the connection is refreshed so that the new name is recognized, and the name of the table or the complete Select query of a field “type Select” is changed, when generating sources it gives an error saying that the field has a query to a table that does not exist and the message shows the OLD name of the Table.
If the SQL is checked in the Lookup Method of the field and also for greater security it is reloaded with the create select tool, the table appears with the new name that it currently has in the DB. Well, the Form is saved, it tries to generate fonts and it returns an error. It is as if a variable internally saved the original name and did not change it.
Verification:
1 - Delete cookies and re-enter Scriptcase.
2 - The name of a table is changed in BD MySQL.
3 - A connection 2 is created to the same DB.
3 - In Scriptcase, change to another connection to the same DB in Menu -> SQL of the Form and save (to refresh).
4 - We select the table that has collected in the list of tables of the connection, it is correct !, it is with the new name !, it is selected and saved.
5 - In Applications -> Synchronize table, OK.
6 - Check that the field has the Select with the correct table name, IF it is correct !.
7 - Generate Sources -> ERROR. It does not recognize the name of the table.
8 - We change the name of the Table in BD for the old one.
9 - We change the name of the Table in the select field Select -> It works.
???
