Nadya,
I found that only 3 applications were affected and simple change of opening "Description" table in buffering 5 mode fixed the problem. I have OpenTble function, so all I had to do was adding last parameter 5 in form's Load in these three applications, so it took me ~1min. to fix all three.Great! Sometimes things work out that well - too seldom however
Another story, how long does it take to understand the source of the problem!!!!!! :)It's never a
problem. Managers call it a
Task ;-)
Honestly, I think the internal handling of the VFP-Grid is either very primitive or very complex. I guess it's a bit like the JanusGrid that only fetches the data visible (and a few more) at a time. That's why it can be so fast. If you fill a flexGrid with a few thousand records, You have to wait like hours; in the VFP-Grid the data is there at once.
What You've done works but under some circumstances seems to be a bit too much for the poor grid. Maybe it's not even the grid but the construction buffered table related to a non-buffered non-updatable cursor. It's probably like apples and pears. Buffering finally causes that You are not ON the table (or there's a backup).
Anyway, Good that You finally sorted it out.