Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Undocumented SYS(1104) function
Message
From
01/01/2002 16:22:28
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00598838
Message ID:
00599612
Views:
27
>>> To refresh a table before reporting, we usually issue an RLOCK(0) (table header) and then run the report. All data displayed in the report is the most current.
>>
>>You don't release the lock ?
>>This prevents other users from adding new data do table during report preview !?
>
>No. The lock is immediately released. The simple act of locking refreshes the data. I posted this instruction in other messages on this subject. This text just didn't make its way into this one.

I use your earlier suggestion. however, how to refresh all tables: I need to make loop over all opened tables in current data session.

* forcebufferrefresh method

lpara lcAlias
if rlock( str(int(recc( m.lcAlias)*rand())), m.lcAlias)
* it updated; continue processing
unlock in (m.lcAlias)
else
* don't know; you decide what you want to do
on error NOTE
inkey(1)
seterror()
endif
Andrus
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform