It's possible that more than one Stonefield Query project has the same data dictionary. For example, suppose you created a project for an accounting application. Then, you created a project for a contact management system. Now, you wish to create a project that links tables from both of these systems. Rather than recreating the data dictionaries for these two applications, you can simply add them to a new project.

The best way to do this is to rename the metadata files (REPMETA.DBF, REPMETA.CDX, and REPMETA.FPT) in the first project directory to something applicable (such as ACCTMETA.DBF, CDX, and FPT) and copy them into the second project directory. Then, edit the SFQUERY.INI file to specify the additional metadata file:

[Meta Data]
file1=repmeta.dbf
file2=acctmeta.dbf

After adding the data dictionary files to the project, create relations between the appropriate tables in the different databases so Stonefield Query knows how to join them.

You may also wish to add existing scripts to the project as well.

The last file listed is the one written to by Stonefield Query Studio. This means new fields and tables are added to that file only, and even changes to fields and tables that exist in other files are written to the last file instead. This allows someone to make changes in Stonefield Query Studio and not have those changes overwritten when a new copy of the other data dictionary tables is released.


© Stonefield Software Inc., 2023 • Updated: 08/29/18
Comment or report problem with topic