Removing fields from the SQL of a Grid

Scriptcase 8 Discussion
#1

In a grid, removing fields from the SQL statement, does not remove the fields from the Fields list.

I’m sure this is not correct. How can I be allowed to set field properties for fields that are no longer included in the SQL statement? In the Forms, there is a Field Sync feature that allows me to add or delete fields if the database has changed, however there is no such feature in the Grids. How do I tell the grids “Fields” tree that 2 of the fields it has listed are no longer included in the SQL statement that the grid is based on?

#2

You mean that if you save the SQL statement that the field list is not refreshed? What if you close the app and re-open?

#3

Yes aducom, that is the case. The field list is not refreshed.