Change Tables in Studio (Magic xpa 2.x)
This property determines whether a Magic xpa project in Development mode can alter the table structure of an underlying database table.
If Change Tables in Studio is checked, then when you make some change to the table definition in the Data repository, Magic xpa will automatically take care of converting the actual table. Magic xpa will convert the actual data (if any exists) and also the definition of the table within the DBMS.
The default for this property depends on the type of database selected in the Default Database property of the Environment dialog box. If the Default Database is an SQL-type database, then the default for the Change Tables in Studio property will be a ‘not selected’ check box. If the Default Database is an ISAM-type database, then the default for the Change Tables in Studio property will be ‘selected’.
The default may be set to a ‘selected’ check box when building the table structure, before data is entered, and before the project goes into production.
During development, It is recommended to have this check box selected. Magic xpa will then ensure that its definition and the physical table structure are the same.
Memory tables – When you delete a Memory table, the Change Tables in Studio property has no effect, meaning that the table will still be deleted.
Local tables – This property is not supported for Local tables.
How Do I Account for Incompatibilities in Table Structure Between Magic xpa and the Database?
