...is a DELUXE LTOOL which allows you to view the data in the various MS Access tables in your Legacy databases.
To view data in the various MS Access tables in your Legacy database:
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.
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\
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.
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.
Click to execute the SQL query that you have entered in theSQL textbox.
Click to close this dialog.
You can use the ? (on the caption bar) or the \