home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Monster Media 1993 #2
/
Image.iso
/
database
/
p4w_all.zip
/
TI1248.ASC
< prev
next >
Wrap
Text File
|
1993-03-09
|
4KB
|
133 lines
PRODUCT : Paradox for Windows NUMBER : 1248
VERSION : 1.0
OS : WIN
DATE : March 9, 1993 PAGE : 1/2
TITLE : Printing the structure of a table
Intended Audience:
This is for all users of Paradox for Windows
Prerequisites:
Familiarize yourself with File | Utilities | Info Structure from
the Desktop of Paradox for Windows
Purpose:
After reading this document, you'll be able to get a printout of
any table structure.
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.
The table structure is readily available from the Main menu of
Paradox for Windows when viewing a table. From the Main menu,
select:
File | Utilities | Info Structure
A dialog box will appear which allows you to inspect all details
of the active table. In addition to creating the dialog box,
from which there is no means to obtain a printout, a temporary
structure table (Struct.db) is also created. This table will
serve as our source table to print from.
Press the "Done" button on the dialog box to return to the
Desktop. From the Main menu, select File| Open | Table | and
select: :priv:struct.db. This table contains 12 fields
depicting information about the original. A sample Struct.db
table is pictured on the next page.
PRODUCT : Paradox for Windows NUMBER : 1248
VERSION : 1.0
OS : WIN
DATE : March 9, 1993 PAGE : 2/2
TITLE : Printing the structure of a table
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
An Instant report on the Struct.db table will yield 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 the additional information on Validity checks
is wanted in a formatted layout, design a report for future use.
In general, you'll find that designing a few reports for various
purposes, all specifying 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.