Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Record is in use - FOUND IT!
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00660857
Message ID:
00661134
Views:
35
This message has been marked as a message which has helped to the initial question of the thread.
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.
Regards from Berlin

Frank

Dietrich Datentechnik (Berlin)
Softwarekombinat Teltow (Teltow)

Frank.Dietrich@dd-tech.de
DFPUG # 327
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform