home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
DP Tool Club 31
/
CDASC_31_1996_juillet_aout.iso
/
vrac
/
del2faq.zip
/
TI1248.ZIP
/
TI1248.ASC
Wrap
Text File
|
1995-12-08
|
5KB
|
126 lines
NUMBER : 1248
PRODUCT : Paradox
VERSION : All
OS : WIN
DATE : December 8, 1995
TITLE : Printing the Structure of a Table
Intended Audience:
------------------
All users of Paradox for Windows
Prerequisites:
--------------
Familiarize yourself with how to view the structure of a table.
Purpose of the TI:
------------------
This document demonstrates how to print the structure of a table.
To print the table structure of all tables in the working
directory, refer to Technical Information Sheet #1672, "Creating
a Table Structure Inventory Using a Script."
Obtaining a printout of the structure for a table is desirable
when using Paradox for Windows interactively or when programming
in ObjectPAL. This Technical Information Sheet deals with the
specifics of obtaining such a printout easily. In order to print
a table structure, you must first view the structure and create a
structure table. The procedures for viewing a table structure
and creating a structure table differ in version 7, 5.0, and
versions prior to 5.0, consequently different sets of
instructions are presented below.
VIEWING AND CREATING A TABLE STRUCTURE - PARADOX 7
1. To view a table structure, choose Tools | Utilities | Info
Structure.
2. From the Select File dialog box, select a table name and
choose Open. The Structure Information dialog box
appears.
3. Choose Save As. The Save Struction Information As dialog
box appears. As a default the structure is saved as
STRUCT.DB in the private directory. Choose Save. To
print the structure of the table, refer to "Printing the
Structure of a Table" in this document.
VIEWING AND CREATING A TABLE STRUCTURE - VERSION 5.0
1. To view a table structure, choose Tools | Utilities | Info
Structure.
2. From the Select Name dialog box, select a table name, and
choose OK. The Structure Information dialog box appears.
3. In order to be able to print the structure, you must first
save this information, by choosing Save As. The Save
Structure Information dialog box appears. In the File
Name text box, type :PRIV:STRUCT.DB. Choose OK to save
and return to the Structure Information dialog box.
Choose Done to return to the Desktop. To print the
structure of the table, refer to "Printing the Structure
of a Table" in this document.
VIEWING AND CREATING A TABLE STRUCTURE - VERSIONS 1.0 AND 4.5
1. To view a table structure, choose File | Utilities | Info
Structure.
2. From the Select Name dialog box, select a table name, and
choose Done. Paradox displays the Structure Information
dialog box and creates the STRUCT.DB temporary table in
the private directory.
PRINTING THE STRUCTURE OF A TABLE
From the Main menu, choose File | Open | Table and select
:PRIV:STRUCT.DB. The :PRIV:STRUCT.DB table contains 12 fields
that depict information about the original table. A sample of
this table is pictured below.
Field Name Type Size Comment
-------------------- ---- ---- ---------
Field Name A 25
Type A 1
Size S
Key A 1
_Invariant Field Id S
_Required Value A 1 Validity Check
_Min Value A 255 Validity Check
_Max Value A 255 Validity Check
_Default Value A 255 Validity Check
_Picture Value A 175 Validity Check
_Table Lookup A 81 Validity Check
_Table Lookup Type A 1 1=Just Current field,
Fill no help
2=All Corresp. Fields,
Fill no help
3=Just Current field,
Help & Fill
4=All Corresp. Fields,
Help & Fill
A quick report on the :PRIV:STRUCT.DB table yields a multi-
pagewidth report as a default with no formatting. This may
suffice if the objective is just to print the Field Name, Size,
Type, and Key. If you want additional information on Validity
Checks in a formatted layout, design a report for future use.
In general, you will find that designing a few reports for
various purposes, all specifying :PRIV:STRUCT.DB as the table in
the data model, will make it easy for you to get the structure
information you need quickly and easily.
DISCLAIMER: You have the right to use this technical information
subject to the terms of the No-Nonsense License Statement that
you received with the Borland product to which this information
pertains.