SQL Environment

Top  Previous  Next

dmc_sql_envir_wizard

 

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

 

dmc_sql_envir_general

 

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

 

dmc_sql_envir_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

 

dmc_sql_envir_keyscols

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

 

dmc_sql_envir_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.

 

dmc_sql_envir_generate

 

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

 

dmc_sql_envir_generated

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 :

 

dmc_sql_envir_query

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

 

dmc_sql_envir_queryOK

 

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.

 

dmc_sql_envir_mt_query

 

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

 

dmc_sql_envir_mt_query_res

 

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

 

Click on the "SQL Script Editor" Tab

 

dmc_sql_envir_mt_query_exp

 

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

 

dmc_sql_envir_mt_query_resfilled

 

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

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

 

dmc_sql_envir_mt_query_resmes

 

and finally the Table :

 

dmc_sql_envir_mt_query_restable