View Legacy Tables

...is a DELUXE LTOOL which allows you to view the data in the various MS Access tables in your Legacy databases.

Screen:

uri/../images/deluxe-view-legacy-tables.jpg

Usage:

To view data in the various MS Access tables in your Legacy database:

  1. Open your Legacy database in _LTools_.
  2. Double-click View Legacy Tables in the Deluxe LTools tree to bring up the dialog for this LTool.
  3. Either:

    1. Select the Table Name that you wish to view. Then, if desired, select an optional Column Name and add a Like clause to filter your results.
    2. Or enter a Custom SELECT statement. (NOTE: You can even join tables or use sub-selects.)

  4. Click the Run button.
  5. _LTools_ will the display the requested rows.

Fields:

uri/../images/bluepin.gif Clear SQL

Click this to clear the SQL textbox.

uri/../images/bluepin.gif   Table Name

If you are not entering a Custom SELECT statement, select the name of the specific Legacy table you wish to view.

uri/../images/bluepin.gif   Column Name

If you are not entering a Custom SELECT statement, and you wish to supply an SQL LIKE clause in order to filter your query, select the name of the column on which you would like to filter.

uri/../images/bluepin.gif   Like

If you are not entering a Custom SELECT statement, enter the text to be used in the SQL LIKE clause. For example, if you selected tblLR as the Table Name, and Location as the Column Name, you might enter *Cuyahoga* here in order to find all locations that contain the substring "Cuyahoga".

uri/../images/bluepin.gif   Generate CSV

Press this button to create a text file in CSV (comma separated value) format, including a header record, from the result set. You can save this file with a .csv extension and open it in any spreadsheet program to see and manipulate the results.

uri/../images/bluepin.gif   Enter Custom SELECT

Use this box to enter a custom SQL SELECT statement. Entering something here will cause _LTools_ to ignore the Table Name, Column Name, and Like fields.

Click here for help writing SQL query and update statements.

NOTE: Right-clicking on this field brings up a context menu containing some "canned" SQL SELECT queries. If you wish to add your own you may do so by editing the MySelectQueries.csv file in your _LTools_ Application Data folder (In WinXP that is C:\Documents and Settings\\Application Data\Zipper Software\LTools\ ). Queries may contain parameters ({parameter-name}). When _LTools_ encounters a parameter it will prompt the user to enter some text. The text entered will replace {parameter-name} in the resulting query.

Once loaded, the window's title will display the name of the loaded query.

Any updates you make to MySelectQueries.csv will not get overlaid when you install a new version of _LTools_.

uri/../images/bluepin.gif   Table Help

Press this button for a brief description of the various tables in your Legacy database.

uri/../images/bluepin.gif   Results

This is where _LTools_ will display the results of your query. Note that you can click on the column headings to sort the results by the particular column. Clicking once will sort in ascending order. Clicking again will sort in descending order. In addition, you can right-click on the top left corner (Select All button) to bring up a context menu which will allow you to show/hide columns. This will affect the display and print, but not CSV.

uri/../images/bluepin.gif   Rows selected

The number of rows of data in your result set.

uri/../images/bluepin.gif   Run

Click to execute the SQL query that you have entered in theSQL textbox.

uri/../images/bluepin.gif   Close

Click to close this dialog.

uri/../images/bluepin.gif   Help

You can use the ? (on the caption bar) or the \ key to display help for this dialog.



Introduction | Deluxe Features | Find Missing Information | Send Legacy Reminders | Tidy Legacy HTML | List Events | Find Unattached Multimedia | Add Events | Add To-Do's | Address Converter | Advanced Set Living++ | Advanced Tagging - Tag Living | Backup/Restore USR Files | Copy Master Event | Delete Master Events | Advanced Tagging - Y-DNA | Get IPTC Data | Global Text Search | Merge Basic to SourceWriter Sources | MRIN Filing Assistant | Repair Multimedia Paths | RegEx GEDCOM | Run Raw SQL | Set IPTC Data | Set Picture Captions | Set Special User IDs | Sort All Children | Sort Children of Tagged Individuals | Sort Events | Sort Marriages by Date | View Legacy Tables | Rename Non-Unique Multimedia | Advanced Tagging | Advanced Tagging - Ancestors Plus | Advanced Tagging - Mito DNA | Create Unknown Spouses | Remove Dead Multimedia Links | Data Bridge | Save/Restore Tags | Link Unattached Multimedia | Standard Features | Set Private/Invisible | Change To-Do Priorities | Clear IPTC Data | DAR Lineage Worksheet | Delete To-Do's | Include Citations by Surety Level | Include Citations by Verified Flag | Remove Medical Notes for Living Individuals | Search Citations | Search File IDs | Set Individual User IDs | Set Marriage User IDs | Set Birthday/Anniversary/Death Reminders | Set Source Surety Levels | Set Source Verified Flags | System Requirements | Contact Info | Miscellaneous Help | Legacy Tables | Product Registration | Edit Preferences | Command Line | Legacy Tables - tblSX.Type | pedigree.css | Source Template | Event Template | About Wiki Web Help | Miscellaneous Tools | Convert Long to Short U.S.A. Location Names