Data Builder FAQ’s

How do I change the name of a DBC or move tables from one DBC to another without losing all of the information I have set up in the Data Builder?

To change the name of a database you need to make the change outside of VPM and then update the VPM data dictionary tables manually. When you rename a database you have to fix the back link in the header of each table in the database. To do this, just open each table in VFP and you will be prompted to find the table's database. VFP will then fix the back link. To update the VPM data dictionary, find the database’s record in the SDATADDD table and change the entry in the cName field.

To move a table to another database, you would follow the same procedure. Move the table to the other database outside of VPM and then update the VPM data dictionary tables. To update the VPM data dictionary, first find the record in the SDATADDD table for the database that now contains the moved table and make note of the value in the cPK field. Then, find the moved table’s record in the SDATADDTV table and change the entry in the cFK_DDD field to the cPK value noted in the previous step.

 

More:

Forms and Controls FAQ's