Restructure Table

How to Access

  • Main Menu | Maintenance | Create Table after pressing the Next button.

Keeps a log of your updates and creates code you can use to propagate your table modifications. You can either commit changes directly or save the code so it can be compiled and sent to remote sites to perform automatic restructuring.

Click Commit to make changes on the server and to generate the DataFlex .FD and .INT files. Alternately use the Save options in the individual tabs (see descriptions below).

Note

Once you click Commit` the changes are applied and the dialog box closes. Scripts and source code are no longer available.

The Tabs

  • SQL Script: Shows the script that can be submitted to the SQL Server to propagate the updates to customer sites. Click Save to save the script for the currently selected table. Click Save All in one script to save all the scripts in one file.

  • INT File Tab: Displays the new INT file for the selected table. Click Save to save this INT file. The new INT file can be copied directly from the saved location or it can be copied from the development drive once the changes are committed and the new INT file is generated. If more than one table was updated be sure to save all the INT files.

  • Log Tab: Lists the operations you performed. Click Save to save the log file.

  • Source Code Tab: Lists the DataFlex restructure code for the operations you performed. If you have made changes, a new button appears at the bottom of this tab, Settings. Click this button to show the Source Settings dialog. Click Save to save this source code in an INC file.