Dear NetMake,
This bug started in version 9.0.38 as I can recall, but I realized why it was coming up today when I created a new Grid application. I thought at first I did something wrong, but was able to re-produce the error.
Here is the way in which the error comes up…
When I make changes to the MySQL table outside of Scriptcase by removing a field and then generate a new Grid application in Scriptcase (confirmed in v9.0.039 for sure) I received an error indicating that a field does not exist.
A lot of times if generating a Grid I just accept the defaults then this error will surprise me and you’ll think you did something wrong. Somehow Scriptcase is not reading the actual table, but relying on a buffered (cached) version. (Which in this case contains fields that do not exist)…
If you could somehow add a “Refresh” into the generator that re-reads the actual table structure before displaying it (the SQL in the Grid in this case) then this error will be GONE.
I can get around this issue now since I know about this issue.
This same issue may persist in other application types. I have not tested other types besides Grid.o, anytime we select a different database or table could a refresh be made to the selected table so as not to have an error or inconsistency occur.