>>If I then clear (ZAP) the table (on page on) and then
>>add a record to the table (so now there's only one
>>record in the table) and switch to page two the grid
>>shows that there are no records in the table.
>>
>>What's happening?
>
>Ok, I figured out what's happening but I still don't know
>how to fix it. In order to ZAP the table I must first
>open it exclusivly
>
>SELECT ProfileSrc
>
>lnOldBuffering = CURSORGETPROP( "Buffering", "ProfileSrc")
>USE (DBF()) EXCL
>
>ZAP it, and then re-open the file and set the properties
>
>USE (DBF()) ;
> ALIAS ProfileSrc
>CURSORSETPROP( "Buffering", lnOldBuffering, "ProfileSrc")
>
>Somewhere in this process the grid columns get destroyed.
>
>I discovered this because I use one of the cells in the
>grid to search for values in another table. After clearing
>ProfileSrc I get an "Unknown Member" error. Also when
>the grid is displayed it comes up totally blank with no
>headers or gridlines.
>
>Like I say, I know what's happening, but don't know how
>to fix it.
>
>Anyone???
>
> ...kt
You have to blank the grids .RecordSource BEFORE you zap the table. What's happening is you are "killing" the table the grid is talking to. Then just reset the grid .RecordSource after you've zapped it.