Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
List of open tables
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01611852
Message ID:
01611870
Vues:
58
>>>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform