Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
List of open tables
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01611852
Message ID:
01611870
Views:
59
>>>What is a best way to get a list of OPEN tables?
>>>
>>>I need to get a checksum of the current record in every currently "open" table.
>>>Either in an array or a table, so I can then use the SYS(2017) function to get each checksum.
>>>
>>>Then I will add them up to come up with a single Combined Checksum to make sure the data set is not being repeated.
>>>
>>>Thanks.
>>
>>AUSED() ?
>
>That's it !
>Been looking for it all day!
>THANKS.

Cyrus, AUSED will only list tables in the current datasession (if you omit the second parameter), you might need to iterate thru all datasessions to get all the tables open (if applies). To get the sessions you can use ASESSIONS(laSessions), something like:
lnSessions					= Asessions(laSessions)
for lnSession = 1 to lnSessions
	* get open tables using Aused(laUsed, laSessions[lnSession])
next lnSession
It might not be necessary in your case, but I thought it would be good to bring this up just in case
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?

"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare

"To die for a religion is easier than to live it absolutely"
Jorge L. Borges
Previous
Reply
Map
View

Click here to load this message in the networking platform