>>> 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