>Nick,
>
>Sorry to bother you again. I thank you for all your help. However, with this example you have given me to try I still get an error that the Alias name is already in use. For some reason the table is not closing properly. Any other suggestions?
The other suggestion would be to create a cursor in the load of the form:
create cursor myGridCursor (lSelected L, ....)
select * from MyTable where .. into curTemp
select myGridCursor
append from dbf('curTemp')
use in curTemp
When you need to re-run selection, do
select myGridCursor
zap
append from dbf('curTemp')
Use myGridCursor as a recordsource for your grid. This way you don't have to worry about grid reconstruction issues. It could be slower, than using result of select directly, but if you're producing just small amount of records, the difference in speed would be unnoticable.
If it's not broken, fix it until it is.
My Blog