|
Xcase Generation Features
All of the code generated by Xcase is produced using TCL, an
extremely powerful, yet easy to learn and easy to use, scripting language that
is far more powerful than the simple macro constructs provided by other tools.
A customized version of TCL is supplied with Xcase in order to allow full
access to all of the metadata information, including user defined attributes,
both in the Xcase Data Dictionary and in the Database Catalog.
Xcase automates your work by automatically generating
and maintaining virtually any database related code:
DDL Code
DDL (Data Definition Language) Code to physically build the
basic structures such as tables, indexes, etc., required to hold data.
Integrity Code
Code to safeguard database integrity via Triggers, Stored
Procedures and Constraints which enforce Referential Integrity, Business
Rules, etc. when inputting data.
Code to Extract Data
Code to extract data from the database via Views and Queries
Modern databases are often complex and contain numerous
relationships. Xcase "knows" its way around your model and is able
to combine a series of relations into "paths". This greatly
facilitates the definition and especially the maintenance of SQL Views which
allow you to accurately extract relevant data from the database. You are not
required to write a single line of code nor to manually maintain the complex
SQL statements which are automatically generated and maintained by Xcase. In
addition, when you change field names, drop fields or modify keys, Xcase
automatically maintains the code.
This unique and extremely valuable feature is not offered by
any other product on the market.
Object Oriented Code
Object Oriented Code specifically built for the target
application to provide all of the important metadata required to manipulate
the databases. For example, Xcase automatically generates data modules for
Delphi from selected entities and views in Xcase and incorporates them into
the Delphi project. Not only is this a powerful time saving feature, but it
ensures consistency and integrity since attributes, validations, etc. are
automatically drawn from the same source, the Xcase metadata.
|
