Is there anyway to print the infostructure of a table in pdx7?
--
Jerry http://www.connected.demon.co.uk
Is there anyway to print the infostructure of a table in pdx7?
--
Jerry http://www.connected.demon.co.uk
: Is there anyway to print the infostructure of a table in pdx7?
Yes. From the Info Structure or Restructure dialog box, click on
"save as;" this does not save the actual table, but saves the
structure information to a table name that you specify.
In PW 1.0 and 4.5, the default name was :PRIV:STRUCT.DB, so I
still use that name for compatability purposes. I've created my
own report based on :PRIV:STRUCT.DB, to get all the information
I'm interested in to print concisely on one page.
Also a hold-over from previous versions: a table named
:PRIV:STRUCT.DB will be automatically deleted at the end of a
work session, much the same as :PRIV:ANSWER.DB, :PRIV:CHANGED.DB,
etc., even though it's no longer automatically created as it was
in versions 1.0 and 4.5.
This is also the way to do it in version 5; in earlier versions,
:PRIV:STRUCT.DB is automatically created whenever you do a
restructure or info structure.
--
=================================================================
=================================================================
I use a handy script that uses the emunfieldstruct and enumindexstruct
methods to generate struct.db and index.db tables, then print out a report
using these tables, to show the field structure information as well as
secondary index info on one report.
here is a code sample to show the enumfieldstruct and enumindexstruct
methods
tbl.enumfieldstruct("STRUCT.db")
tbl.enumINDEXstruct("INDEX.db")
Drop me an email if you would like the actual script, I don't mind sharing
it.
--
Greg R. Johnson
Union Tank Car Company
1. Print Info/Structure for all DB in Alias
Hi all;
I would like to know if there is a way in Pdox 7 to print the
info/structure for all tables in a given alias.
I could probably do this myself but why re-invent the wheel.
Thanks a lot in advance.
--
Mark L. Bartlett
Overland Park, KS, USA
http://www.qni.com/~mbartlet
2. Altering db size doesn't update Enterprise Manager?
3. Lots errors with Index or structure tables on PDX7.00
4. Test Post
5. Pdx7 Run Time - Memo Field Printing Problem
6. How do I determine the SQL engine in use?
8. Browse Screen Flicker FPW2.6a
10. PDX7 and HP 70Sce Deskjet printing problems
11. PDX7 Report Printing Problem
13. Structure info