How VisualRep Works -
Database & Metadata
|
|
Reading the
Database information
VisualRep reads all data
dictionary elements automatically from each database type. This includes
tables, relations, fields name, fields format and captions. This
functionality allows even inexperienced users to easily create reports
by running a query wizard. The Databases are: MS-Access, SQL Server,
Oracle, FoxPro Databases, DBCX and Promatrix Data Dictionary.
|
Dynamic Update
If any table was removed from any data dictionary such as: VFP or MS
Access databases then this table will be automatically removed from the
list of available tables. All queries and reports based on the
removed table will alert the user on the problem. The user will have the
opportunity to rectify the problem. |
Switch Between Database
Provides point-and-shoot to switch between different databases. |
Add
External Table
You may require to use some external table that is not included within
the Visual FoxPro database or any data dictionary. Those tables could be
either free tables or none free. For instance some tables from a
different application. By selecting those tables they will be added into
the VisualRep Data Dictionary.
|
|
This option is available for Visual FoxPro
database, VPM and DBCX Data Dictionaries. It is not allowed for client
server databases such as MS SQL, Oracle and MS Access. |
 |
|
|
