Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to refresh buffered table ?
Message
 
 
To
29/12/2000 06:29:52
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00457699
Message ID:
00457732
Views:
29
John,
Take a look at SET REFRESH in the VFP Help. The second parameter will determine how often VFP goes back to the network to refresh its local cache.

I have heard of problems using SET REFRESH when tables are opened in the default datasession at application startup and then used again in forms with private datasessions. One way I know of to get around this is to issue an RLock() on a record and immediately release it. The locking will cause the local cache to refresh itself. You could add this in the Init of your form to refresh the data when the user first enters the form or add a timer to your forms that performs this on a regular basis.

This has a performance hit if operating over a "slow" network because it generates a significant amount of traffic.

HTH.

>HI,
> Why my native table (with table buffering) is not refresh even I have issue USE IN mytable?>
>
>1. I have a customer data entry form which allow user to key in / update /seach /delete customer info.
>2. I will launch s search form which list out all of the customers in grid.
>3. After user select record in search form, the selected record will be LOCATE again in customer form and display it.
>
>It work fine in single user mode. However, I have a problem in multiuser environement.
>
>I have a simple test:
>1. I have 2 instances of my EXE.
>2. I repeat the steps 1-3 mentioned above for both of the instances.
>3. Then, I update the selected record in 1st instance.
>4. I go back to 2nd instance and launch search form again. The data in this form is not updated (which updated in 1st instance), even I release the form after I select the record and issue USE IN mytable in FORM.UNLOAD.
>
>Any idea?
>
>Thank you
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Reply
Map
View

Click here to load this message in the networking platform