>>When I am using a grid with the record source as MYCURSOR, to keep the grid objects from being released when I issue a SELE....INTO CURSOR MYCURSOR statement to requery, I set mygrid.recordsource="" before the SQL , then restore recordsource to "MYCURSOR" after the statement.
>>
>>Here's the problem...I have customized columns, but when I set mygrid.recordsource to "", it sets all the columns recordsource to "" as well. I have to reassign them each time. Is there a better way to do this?
>Larry,
>
>The complete solution to this is to use a view isntead of an sql select. You can requeey() a view without doing any somersaults with the grid.
I agree, but it was easier in this situation to do an SQL select to cursor instead of setting up a View....at least it seemed like it at the time. I'll re-check...