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