Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How does VFP fetch data in buffering mode?
Message
From
29/12/2000 09:59:09
 
 
To
29/12/2000 08:22:40
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00457209
Message ID:
00457741
Views:
16
> Yes, I am using table buffering - 5. I did issue TABLEUPDATE() in 1st instance and it return .t. too. The data in seach form (1st instance) give me the most updated data. But, the 2nd instance doesn't. Any mistake here?
> Lock record? Do you meant I need to LOCK and UNLOCK the table when i am updating reocrd in 1st instance?

Hello, John.

I think I didn't understood your problem before.
If the situation is that you reach the same record in both instances, edit it in the first one, update changes, and then, when you switch to the 2nd the data doesn't reflect the change, all you need is to refresh it.

Try putting THISFORM.REFRESH() in the form's activate. You'll see the data changing as soon as the form gots focus (not sooner). If you want the form to reflect the change even without getting the focus, you have to scan trough the forms collection of _SCREEN and refresh them all (or maybe the ones that have the same name or caption that yours), after you issue TableUpdate().

Please tell me if I wasn't clear.

Good luck.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform