Information générale
Catégorie:
Codage, syntaxe et commandes
>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement