|
With DMC Viewer you will be able to :
| • | Visualize all your data from any table (SQL one's also of course) |
| • | 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 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 buttons click |
| • | View all 'fields' in an array in the same listbox |
| • | 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 |
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 PostGreSQL tables NOT being fully compliant to SQL standards (column & key names in mixed case and not all lowercased) will not let all features of the Viewer be enhanced - a message will inform you of this situation
| 
