Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Refreshing data in form with private data session set
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01330654
Message ID:
01330688
Views:
21
>>>>>A from with a private data session and table buffer set at optimistic table buffering (5) for a table in the data environment. How can I refresh my data environment without closing and reopening the form?
>>>>
>>>>If I remember correctly, if the data is based on a view you can call the refresh() function. This is often done in a parent-child scenario, when you want to change the view to show data for another parent record.
>>>
>>>so would i have to call the data environment objects close tables and then the open tables?
>>
>>You should not have to close tables, but the question was is it a Table or a View? If it is a view you can use REQUERY("ViewName"). If it is a table then the question is if it is possible that you modified this table prior to refresh?
>
>
>Form has a private data session. Data environment contains tables. Tables are buffered (5). User has form open. In the mean time another user has updated some information to the table. If user closes and opens the form again, the form will show the new changes. Looking for a way to "REFRESH" the controls. In my mind i need to get the data enviroment refreshed to include the newly updated information.

Check for SET REFRESH
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform