JavaScript Editor js editor     Web development 

Main Page

When you move database (.dbc, .dct, and .dcx) files or a database table, the relative paths change and might break forward links and back links that Visual FoxPro uses to associate database and table files. You can reestablish links and update the relative path information to reflect the new file location.

If you want to open a table without reestablishing links for all tables in the database, use the USE command. Visual FoxPro displays the Open dialog box so you can locate the database that owns the table or delete the links. For more information, see USE Command.

You can also remove the database reference, or back link, from a table.

To update links between a database and its tables

  • Use the VALIDATE DATABASE command with the RECOVER clause

For more information, see VALIDATE DATABASE Command.

For example, the following code opens a database named MyDatabase and displays dialog boxes to help you locate those tables that are not in the locations stored by the database:

В Copy Code

To remove the back link from a table

  • Use the FREE TABLE command.

    Do not use FREE TABLE to remove a table from a database if the database exists on disk; use REMOVE TABLE instead. If the database exists on disk, FREE TABLE might render the database unusable.

For more information, see FREE TABLE Command.

See Also

JavaScript Editor js editor     Web development