SQL Environment

This will let you enter a complete SQL environment from where you can do many tasks on ANY SQL able

You have 4 Lists on this screen plus a manual or "assisted" query builder

The first List contains all registered ODBC connections

A double-Click will List in the second list all the related Tables

Again a double-click on ANY Table will List the KEYS and COLUMN in the last two Lists

You will also have the number of records in the selected table displayed onscreen

From this step on, you can either :

1. Directly open this table in the Viewer (full mode with Mass Update and QBE etc ...) and REVERT back to this screen with a special button in the Viewer

You can perform any work needed on the Table here or use the "Back to SQL Editor" button to switch back ..... as many times as need be.

2. Generate random Data for the selected table with the corresponding button and see it displayed on screen and switch back again to the SQL environment screen.

After selecting the number of records to generate, a progress bar will keep you informed of the process

And this screen to visualize the generated data will open up for you

Again using the "Back to SQL Editor" button will bring you back in the main screen

3. Use the Query Builder - Editor to work on any table

From the Table KEY and Column Lists you simply use the drag and drop possibility to add (at cursor position) whatever "element" the query requires

for example you can use this sort of query :

Click on "Run" and depending on success or not a message will popup to let you know

and the Table will be truncated and the number of records onscreen will be refreshed to show success .

The query remains in memory and on screen, which means you can use it several times changing only part elements from it

You can of course do any much more complicated queries like this one to obtain Multi Table subsets you will then be able to export OR TO CREATE a TPS or SQL Table directly from that result set.

When you click on "Run" - after the success message - a new screen will open up with the resulting subset data displayed

You can export to predefined formats with the "Send To" button OR ....

Click on the "SQL Script Editor" Tab

You have now the possibility to export this subset either to TPS or SQL (in the current Data base) Table after defining a valid UNIQUE Table Name and clicking on the corresponding button

After which this new table will be created and all data exported automatically.

(a confirmation message will let you carry on or cancel)

and finally the Table :