Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Downloads
Search: 

LS - LIST STRUCTURE Replacement
John Koziol, Ultimate Software
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), or in Print Preview.
Created on
24 years ago
Downloads
2612
File type
Rating
4.83/5.00
General information
Rating:
4.83/5.00 (6 rates) Rate this item
Description
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(0 or .F. or omitted) && output to screen --or-- =LS(1) && output to print preview window --or-- =LS(2 or .T.) && output to printer Version changes ------------- 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. Version 3.0, bugs fixed, print preview now supported, now fully documented.
Created by
John Koziol, Ultimate Software
John Koziol was an independent consultant and developer off and on for almost 20 years before joining Microsoft in 2001. Since leaving in 2005 he has been involved in several cutting-edge projects using .Net (WPF, C#), SQL Server, and other tools. He is currently a software engineer specializing in model-based testing (MBT) for Ultimate Software in Weston, Florida. He has written numerous articles on VFP related topics for both print and on-line media. He was a Charter Member MCSD and was a...

Comments
Great utility, which I use everytime. Naomi Nosonovsky, July 3, 2001

Now this is a Utility!! Ric Hyden, October 11, 2001

Thanks again, John - worked very nicely for me. Naomi Nosonovsky, June 18, 2009

Add a comment
More downloads created from this member
John Koziol, Ultimate Software
This simple program simulates organization from chaos, such as assembling an RNA chain from an amino acid soup. Type in long phrases and amaze your friends how they can be matched randomly in a relative few generations!
Created on
17 years ago
Downloads
550
File type
Freeware
John Koziol, Ultimate Software
Simple class to convert numbers to ordinals on the fly, ie, 23 to twenty-third. If operates using the _Assign event to automatically handle the conversion. The resulting Verbiage property is upper-case (so use VFP's PROPER or LOWER if desired).
Created on
18 years ago
Downloads
551
File type
Freeware
Rating
5.00/5.00
John Koziol, Ultimate Software
GenLoader creates Windows Script Host scripts that you can use as loaders for Visual FoxPro applications to check for (and replace with) newer versions of the application.
Created on
23 years ago
Downloads
1237
File type
Rating
5.00/5.00
John Koziol, Ultimate Software
The mathematical evolutionary game of Life.
Created on
23 years ago
Downloads
860
File type
John Koziol, Ultimate Software
This is the followup to DBC2MDB which moves Fox data to Access. This file does the opposite; moves selected contents of an Access MDB file to a new or existing VFP DBC and DBFs. Supports just about all data types except General-type fields.
Created on
23 years ago
Downloads
2713
File type
Rating
4.00/5.00
John Koziol, Ultimate Software
The Upsizing Wizards in VFP help us move our data and database schema to Oracle or SQL Server. But what about "downsizing" to Access? DBC2MDB is a wizard that allows you to move your database and table structure to a new or existing MDB and, optionally, move the data itself.
Created on
23 years ago
Downloads
4268
File type
Rating
4.50/5.00
John Koziol, Ultimate Software
This simple class accepts a name in standard first and last name format and then formats it into last, first format. What makes it unusual is that it can handle prefixs, suffixes, and titles with aplomb. Steven Dingle will soon be posting a class on Compuserve that does this same thing in a slig...
Created on
23 years ago
Downloads
884
File type
Rating
4.00/5.00
John Koziol, Ultimate Software
Spellbound is a classlib with a single class, SpellIt. SpellIt is used as a means to spellcheck (with suggestions, changes, and all the other Word spellcheck amenities) any text value. Designed in VFP 6 SP3, but should work if compiled under VFP 5.
Created on
24 years ago
Downloads
872
File type
John Koziol, Ultimate Software
DESI is a complete application written under VFP6 SP3. It maintains clients and can produce invoices. It's a simple application, but includes a simple framework, a database container, and a fair amount of sample code. The purpose of this application is to show how everything can be put together...
Created on
24 years ago
Downloads
2068
File type
Rating
5.00/5.00
John Koziol, Ultimate Software
Bag-o-tricks is a lighthearted VFP6 classlib with classes designed to be dropped into forms to produce strange behavior. It is totally nondestructive and will not harm a fly. Have fun with this!
Created on
24 years ago
Downloads
1876
File type
John Koziol, Ultimate Software
VBPrinter is an ActiveX control that allows precision control over printers not afforded by native VFP functions. It allows for programmatic selection of paper bins, orientation, copies, paper size, and much more. This is a "don't miss" if you require extended printer control functionality. This u...
Created on
24 years ago
Downloads
3562
File type
Rating
4.00/5.00
John Koziol, Ultimate Software
ROC grabs Contacts from Microsoft Outlook 97 or better and puts them into a DBF. Not all properties are "raided", but this simple demo program should help you learn more about the Outlook object model and how to "raid" other things.
Created on
24 years ago
Downloads
987
File type
John Koziol, Ultimate Software
This is a Visual FoxPro DBF of countries, currency name, and official currency code. Nothing more, nothing less.
Created on
24 years ago
Downloads
970
File type
John Koziol, Ultimate Software
conILX is a container that you can dump into any Form. It is an expression evaluator, allowing you to test expressions without using the Debugger. It tracks multiple expressions (no limit). It has the ability to 'lockdown' expressions and save results to a textfile. NEW: Now allows the entry...
Created on
24 years ago
Downloads
628
File type
John Koziol, Ultimate Software
The zip file contains a classlib, class, a dummy table and test form to show a TextBox that allows entry of numeric expressions, like 34+67, and then displays the result. This class requires that the textbox be bound to a numeric or integer column in a table.
Created on
24 years ago
Downloads
837
File type
John Koziol, Ultimate Software
ViewMaster (.09 Beta) is a Visual Tool for VFP6 databases that allows you to edit any local or remote view property or field property. Changes may be applied to the DBC or reverted.
Created on
25 years ago
Downloads
802
File type
John Koziol, Ultimate Software
Autodata is a collection of 4 procedures that automate saving, validating, requerying, and reverting DataEnvironment cursors and views. Autodata is completely automated and uses simple forced tableupdates. It is easy, however, to graft more sophisticated conflict management in an automated fas...
Created on
25 years ago
Downloads
1572
File type
John Koziol, Ultimate Software
Create your own Mr. Spock in VFP6. At the Command Window, do 'Spock=NEWOBJECT("Vulcan","StarTrek")' From then on, you can get one of Mr. Spocks insights by typing ?Spock.Opinion, just like Captain Kirk! This classlib demonstrates the Access method.
Created on
25 years ago
Downloads
962
File type
Rating
4.33/5.00
John Koziol, Ultimate Software
GENCCLASS defines a class called CheckFunctions with a simple property set to convert numbers to printed check-style text. For example: 112.20 = One hundred twelve Dollars and 20 Cents. The class will work in Spanish or English via a Language property. It makes heavy use of HIDDEN prop...
Created on
25 years ago
Downloads
1258
File type
Rating
5.00/5.00
John Koziol, Ultimate Software
This is a simple class to allow formatted and validated entry of 12-hour time values into a textbox, ex: 11:14 PM. Thanks to Robert Keith for starting the thread which led to the idea.
Created on
25 years ago
Downloads
1485
File type
John Koziol, Ultimate Software
Creates program code in a separate PRG file to emulate actions of the DataEnvironment. Useful in converting from using a DE to using hard-coded table openings, buffering, relations, etc.
Created on
26 years ago
Downloads
1269
File type