DMC Viewer > Using the Viewer

You can use the Viewer part of DMC either by doing a double-click on any TPS - DAT or DBF (or any other 'linked' table) Table directly in Windows Explorer

Or from within the Tool itself by selecting "Use DMC Viewer" then your source Driver and then selecting your table (or SQL connection string and then the Table from the List of Tables)

You can define here also all optional settings necessary to open the table (password - OEM - Number of records to read) and you can use the Extension entry field to list different "File Types"

dmc_viewer_check

You can also use the Viewer along with a Most recently Used Table List (quicker access as all settings are stored for you) :

dmc_viewer_mru

A double-click to select the table to open and finally use the 'Finish' button.....

You have the possibility to Delete a selected Table

You also have the possibility to EMPTY completely this table List (confirmation message)

First you have to understand the technique used for the Viewer : we read the table and store in a Que all the data .This means that any modification you do HAS to be saved to File IF you want to save it.

BUT it also means that you can 'play' with your data to obtain whatever you need WITHOUT any risk for the table itself.

Imagine you have a dealer calling you and asking for an extract of his sales during Jan '08 regarding the state of Florida for all his 'top' clients' etc etc .... you are not going to send him all your table .....

This is where DMC Viewer will become very useful for example

As you are working on a Que, you will be able to use all the power of the QBE to get a subset of your data corresponding to your dealer's request and send it to him by PDF for example without 'touching' your main table.

For you to be able to access the QBE and the Mass Update features when opening a table from within DMC, you MUST select to Visualize ALL the records.