> Still wondering though what the advantage would be to using select
> statements vs views. When I tried to use a select statement for my grid,
> the cells in the grid disappeared when I closed the cursor to run the
> select again. I'm probably doing something wrong here, since I am used to
> using views with grids, and just requery()ing.
The reason for this is that the Grid is bound to a ControlSource. The
Grid is 'smart' enough to detect that that ControlSource has been closed
and reopened (when you SELECT into a cursor, you delete the old cursor
and create a new one). This causes all of the data, and all of the
formatting, disappear from the old Grid, and the Data (without
formatting) will appear in the new Grid.
To prevent this behaviour, use:
thisgrid.ControlSource = ""
SELECT ....
thisgrid.ControlSource = "NewCursor"
This way the Grid won't see the cursor close.
/Paul