Software Directory
Our Network
Top Download Titles
|
|
|
|
Stonefield Database Toolkit
|
Visual FoxPro provides something FoxPro developers have needed for years -- a built-in data dictionary. Visual FoxPros data dictionary provides table and field validation, field captions, triggers, even table and field comments.
Unfortunately, many things are missing from the data dictionary, such as structural information necessary to create or update table structures at client sites and useful information such as captions for tables and indexes. Also, the tools Visual FoxPro provides to manage the database container itself are less robust than youd expect. For example, altering the structure of a table breaks views based on that table. Table and field name changes arent propagated throughout the database, resulting in orphaned database objects. Moving a table to a different directory or changing the DBF name causes the database to lose track of the table.
SDT overcomes these limitations and many others weve found in Visual FoxPro, and provides additional functionality that serious application developers need!
There are three aspects to SDT:
It enhances the tools Visual FoxPro provides to manage the database container.
It provides the ability to define extended properties for database objects and set or obtain the values of these properties at run-time.
It includes a class library you can add to your applications to provide database management functions at run-time, including recreating indexes, repairing corrupted table headers, and updating table structures at client sites.
SDT automatically redefines views when you change the structure of a table involved in a view. It propagates table and field name changes throughout the database container, and updates both the database and DBF header when a DBF is moved or renamed.
SDT adds structural information to the data dictionary so you can create tables and indexes or update their structures whenever necessary. SDT includes other extensions as well, defining information such as captions for tables and indexes, and many more.
You can even define your own custom properties whenever you need to. Define security levels, usage information, captions in other languages ... anything is possible. Get these values at run-time to create truly data-driven applications. Change the property in one place, and every form, program, or report that uses it changes instantly.
SDTs class library provides methods to manage databases and tables at run-time. For example, the OpenAllTables() method automatically opens all tables in the database flagged as autoopen.
The most useful class library methods are:
Reindex(), which recreates indexes from their data dictionary definitions.
Repair(), which repairs corrupted table and memo headers.
Update(), which creates or updates table structures according to their data dictionary definitions. |
|
|
|
