We use views and bind them to grids in our forms. When we requery the view (by issuing USE dbname!viewname), the grid.columncount goes to zero because the bound table is temporarily lost. The grid then shows up as a white box with nothing in it.

We are coming up with some complex work arounds for this, but wanted to know if there is a simple solution to not losing the grid columns in the first place.

Any ideas?


Greatly Appreciated :)


Thanks