A utility in the Utilities subdirectory, VMP2SQ.PRG, assists developers using Visual MaxFrame Professional (VMP) by updating the Stonefield Query data dictionary as follows:

  • Primary and foreign key fields are marked as non-reportable.

  • Table captions are read from the first line of the table's Comment property in the database.

  • Relationships defined in the VMPRI table are added to the data dictionary.

This program was originally written by Frank Marafino and kindly provided for other developer's use.

To run this program, open the database containing the application's tables, ensure the Stonefield Query project directory is the current directory or in the VFP path, and then DO VMP2SQ.PRG.