Table Level Tool

SQL Tool
Revision History and Features

0.0.2-beta (2003-06-12)

The checkboxes now "remember" the settings.

0.0.1-beta (2002-12-23)

New checkboxes available for selecting "Quoted Fields" and "Table Extentions". The initial release had all 3 checkboxes enabled.

0.0.0-beta (2002-12-04)

First release.

Features:

SQL Tool is a software tool for using SQL commands, both DDL and DML with Paradox® database tables. With SQL Tool you can easily save the query result as a table. /* you can also use SQL comments in your SQL scripts. */ With SQL Tool you can see the memo fields in the answer-table.

Does not require knowledge of CREATE TABLE structures.

Save tremendous amounts of time by automatically creating complete CREATE TABLE statements that can cut and pasted into your code!

Creates statements for tables with spaces in the table name, or in the field name

Creates statements for primary indexes

Cut and Paste results from SQL Tool to your code, or save the results to a text file.

The results are for Paradox, but the table structure is there. Change the resulting statements some and you can port your tables to Oracle, SQL Server, InterBase and other SQL databases.

Sample code built in for 'Add Columns', 'Add Index', 'Blank out a Column', 'Create Table', 'Drop Columns', 'Drop Index', 'Drop Table', 'Empty Table', 'INSERT' and 'SELECT'.

Bug Reports

If you experience something you think might be a bug in this product, please report it by sending a Bugreport , with a subject heading of Bug Report. Describe what happened, what version of the software, any error messages received, what kind of computer you have, which operating system you are using, and anything else that is relevant.

Product Enhancements

From time to time, everyone comes up with an idea for something they would like their software to do differently. If you come across an idea that you think might be a beneficial enhancement to this product, your input is always welcome. Please send any suggestions or requests for new features to suggestions with a subject heading of Product Enhancement.

Note: As with the use of any software that processes data ensure that you have a valid backup of your data files prior to performing any actions with this application.

Information in this document is subject to change without notice.

Paradox is a registered trademark of Corel Corporation.

Stefan Bodingh
Bodingh Consulting AB
http://www.bodingh.se