Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Printing tables
Message
De
21/04/2000 13:24:34
Cindy Winegarden
Duke University Medical Center
Durham, Caroline du Nord, États-Unis
 
 
À
21/04/2000 11:03:44
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00362244
Message ID:
00362290
Vues:
12
>Is there a way to print table struc. ?
>john

In the files section under Databases:

5. 1123 LS - enhanced LIST STRU replacement
Get annoyed by those word-wrapping list structure printouts? LS replaces the command by formatting the output to comfortably fit on the screen or on a printed page (in landscape mode).

Additionally, LS also lists all structural index tags, views in the same DBC in which the table participates in (with SQL), relations defined in the database, and related RI.

If the open cursor is a view, local or remote, LS prints out the updatable, key, and source column properties as well as all view properties in the report header.

USE table
=LS(.T.) && To Print
=LS(.F. or omitted) && To display

Source code included.

Version 1.1, output now includes field rules and field defaults as well as tabel database name.
Version 1.11, output now includes ALIAS name. Thanks to Doug Dodge for the modifications.
Version 1.5, now list index tags and tag expressions and cleans up after itself better.
Version 2.0, now lists view participation, relations, and RI.
Version 2.5, now detects that the open cursor is a view and shows/prints accordingly.
Version 2.51 Minor bug fix (Thanks, Nick) and added GETFILE to open a DBF if no table is open when LS is called.
John Koziol
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform