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.