|
Viewer |
  
|
|
Viewer |
|
With DMC Viewer you will be able to :
| • | Visualize all your data from any table (SQL one's also of course) |
| • | Hide or Unhide some Columns from the screen (saved and reset option) and in predefined Exports "see" only the unhidden columns |
| • | Export the data as is to CSV and XML (directly using the appropriate buttons) or to HTML-PDF-XLS-WORD etc .... by using the Main Frame's SendTo button |
| • | Build very complex queries (QBE) to obtain a subset of your data (and store them for future use if need be) |
| • | Use expressions and conditions on each column you want to do some Mass Updating on your data |
| • | Save to File your modifications (even on Multi Columned Primary Keyed tables) OR Export them as is without tampering with your original table |
| • | Sort your data by all existing KEY's (depending on the sort order the color will change automatically to help you visualize better your data) |
| • | Sort all columns with click's on the headers (Ascending and descending orders) |
| • | Format any column to be more user friendly (for example a date stored in a LONG field can be displayed as a DATE) |
| • | Visualize the Structure of the table and copy paste it if you need it in your dictionary |
| • | Locate any value in the current column (or in all columns) and use the 'Next' button to carry on your search |
| • | Change any column value with a double-click on it ..... |
| • | Delete any record with the main frame's Delete Button |
| • | Add a new record with the main frame's Insert Button (only in DAT - TPS Ms SQL and MySQL Tables) |
| • | BUILD Keys of the Table (TPS encrypted or not Multi Table or not & DAT) |
| • | Refresh Multi Tabled TPS file Table List |
| • | Empty a Table on a button's click |
| • | View all 'fields' in an array in the same list box |
| • | Switch from one Table to another with a Double-Click when viewing TPS Multi Tables |
| • | As you have a multi-copy licence, use DMC as a TopScan (or other tool) replacement, you then have in the title bar the Name of the opened Table for better Window Taskbar navigation |
| • | Use a real Edit In Place to change any column value with popup Calendar for DATE columns |
| • | Use a BLOB pre viewer with embedded formats of Images - RTF - HTML - XML - PDF - VIDEO - SWF - DOC - XLS documents |
| • | Use DMC to edit a subset of records (select to read the FIRST "X" records or the LAST "Z" records or even read between record "X" and record "Z") |
| • | etc ..... |
This is a screen shot showing you the User Interface on a TPS superFile (MultiTable)
We add a column called DMC RecNb which you cannot see or edit but which allows you to see the Data in it's original sorting order
We have implemented a new technique in the Viewer to let you have the display open up immediately after selecting your table (with the first 500 records filled in and the rest of the data being read under a progress bar)
The main screen will popup after 2 seconds .....
This enables you to open up a 70k TPS Table in under 10 seconds and a 150k SQL table in under 30 seconds .....
Some Tables NOT being fully compliant to our standards will not let all features of the Viewer be enhanced - a message will inform you of this situation (but you will still be able to do all data QBE formatting etc but not be able to save back to Table).
(You need to load the complete Table to have access to those Viewer features (otherwise saving back to File would create many problems)
If you do modifications in a table and click on the Close module button, a message of confirmation will come up warning you to Save them to File ..... (you can of course close without saving)
THIS TASK IS RUNTIME ENGINE COMPLIANT
If you need to perform this task on your clients machines , then SAVE it as a Profile when all is defined and use the Runtime Engine to run it from your application
The different settings on Table Name can be changed dynamically from your application to meet your requirements