How do I delete unwanted fields in a grid application?

Applications Grid / Reports
#1

Here is the order I did things:

  1. Created a new grid app, with the default SQL that selects all fields in a table (customers)
  2. Using “Edit Fields” Made some changes about the fields shown/not shown
  3. Using “SQL” changed the SQL to select only a few fields, (not all), from the customers table

Now, when I enter “Edit Fields”, all the original field objects are still there. I need all the fields that are no longer included in the SQL SELECT field list, to go away. I’ve tried Saving, Generate Source, etc. and I’ve looked for a way to DELETE those unwanted, no-longer selected fields, but there is no Delete field function or menu.

So, I tried to Delete the grid app, but, there is no way to delete the grid app and start over. How do I delete unwanted fields in a grid and How do I delete an app and start over?

#2

Re: How do I delete unwanted fields in a grid application?

dam, answered my own question… the SQL was wrong, and when I clicked Save it was not updating the field list. I fixed the SQL so that it executed, and then the field list was updated.

#3

Re: How do I delete unwanted fields in a grid application?

As a heavy user of programming forums, I have consistently found that that is what forums really are for - a place to fully describe a technical question or problem - post it - then the problem is somehow “freer” to percolate in your brain for a while :slight_smile:

BTW It is nice that you followed up with the answer for other people, who like 5 minutes or 5 months from now, will be searching or reading thru the posts.