I.T. Discussion Community!
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

August Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardObjectPAL Topic   Print This     

Question: How to get a list of open tables?

Question: How to get a list of open tables? in ObjectPAL topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: Question   Question How   Question How get   list of   open tables  
S0nY
Baton Rouge, LA USA

Is there a way to use enumOpenDatabases() or enumDatabaseTables() to get a list of all databases that I currently have opened? Or better yet to get a list of what tables other users ( enumusers() ) have open? I have been trying to figure out a way to write this but so far no luck. Any suggestions out there ?

 Posted 10 years ago (Thread Starter)
Comment Quote
About S0nY -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #14043, 1 replies
Thread Started 4/16/2010 1:42:41 PM
View Counter=2972
Last Reply Posted 4/22/2010 6:24:58 PM)
Location=Baton Rouge, LA USA 
Joined=13 years ago   MB Posts=53  
Most Recent Post
AIBreveleri

I don't know any way to see what tables are opened, but you could examine the lock files (PDOXUSRS.LCK) to see what tables are locked, which should give you the info you're seeking.  But unfortunately the lock file structures are as complex as the table file structures, and Borland never committed to publishing any of its file structures.  But fortunately a couple of Borland techs did write a whitepaper on BDE table locking.  But unfortunately the description is incomplete, and the files are difficult to analyze.  But fortunately I have written a utility (Google 'lockwise bde', or go to http://home.comcast.net/~j.breveleri/lockwise.html) to read and monitor the BDE lock files on a local network.  But unfortunately it only displays the information in real time and does not generate logs (although you can print the realtime dispalys).  But fortunately it is open-source (GPL) so you can read the code and, together with the whitepaper, perhaps understand and read the lock files.

-Al.

 Posted 10 years ago
Comment Quote
About AIBreveleri -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #14049 (Level 1.1)  Reply to 14043
Thread Started 4/22/2010 6:14:47 PM
Location= 
Joined=19 years ago   MB Posts=286   KB Comments=8  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P187A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #14043 Counter
2972
Since 4/16/2010

Follow PrestwoodBoards on: 


©1995-2020 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech