Welcome, Guest. Please Login.
04/27/24 at 09:50:18
News:
Home Help Search Login


Pages: 1
Send Topic Print
Current list of tables (Read 2354 times)
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1924
Gender: male
Current list of tables
03/28/13 at 05:23:45
 
Is there one already available somewhere? If not, is there a way to generate one with the Pervasive utilities?
 
Of course, it would ideally have a description as well as all the fields and their purpose as well, like an updated and expanded "DBAFILE" that I got a decade or so ago...
 
??
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: Current list of tables
Reply #1 - 03/28/13 at 16:35:56
 
I suspect there is a way to generate one using the JDBC connection because the DE-A Query Wizard had to generate the list to know what to present in the wizard.  Let me check into it.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1924
Gender: male
Re: Current list of tables
Reply #2 - 03/29/13 at 04:44:44
 
Got it.
Thanks!
-d
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Prier Products
Full Member
***


I Love YaBB 2!

Posts: 107
Re: Current list of tables
Reply #3 - 03/21/14 at 09:31:36
 
I would love to have this too!
Back to top
 
 
  IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 785
Gender: male
Re: Current list of tables
Reply #4 - 03/21/14 at 11:07:21
 
On your pervasive control center or ms access if you have it (pass-through query)
 
This selects all table names and their corresponding data file names:
Select * from X$File
 
This selects all the fields for a table named 'WORKORD':
 
Select Xf$Name, X$Field.* from X$File, X$Field
WHERE Xf$Id = Xe$File and Xf$Name = 'WORKORD' and Xe$DataType < 200
ORDER BY Xe$offset
 
 
 Tongue
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: Current list of tables
Reply #5 - 03/21/14 at 14:33:47
 
There is also a relatively new Excel file listing the fields and tables on the Resources page of the ISTECHSUPPORT.COM website.  Better than the 10 year old one David was referring to.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Prier Products
Full Member
***


I Love YaBB 2!

Posts: 107
Re: Current list of tables
Reply #6 - 03/21/14 at 14:37:56
 
Thank you Lynn.  Just what I was looking for.
Back to top
 
 
  IP Logged
Pages: 1
Send Topic Print