Now, Appx will analyze the changes that are being made and if they met certain criteria (listed below) then Appx will use SQL commands to restructured the external database. Otherwise, if the new restructuring criteria is not met, Appx will behave as it has in the past.

New restructuring criteria that will cause Appx to use SQL commands:

• Add one or more fields to the end of the file/row
• Increase the size of one or more alpha fields (reducing alpha field size is not supported)
• Deleting one or more fields

• You cannot add date/logic fields as a part of a key, if they are not in varchar/char format in your database
• You cannot, add any field that has null values to be part of a key

You cannot do multiple actions that generates multiple SQL Queries. For example, you CAN add multiple fields to the end of the record, but you CANNOT add a field and delete a field at the same time. The reason for this limitation is that oracle does not support rollback on DML transactions. You still can take advantage of Quick restructure by doing it in multiple steps (Add all your fields, restructure, then delete the fields need to be removed, restructure again).

Appx officially supports Oracle SQL, PostgreSQL and MSSQL. Though MySQL is not officially supported, it will likely work and Appx recommends using 8.0.13 or newer to take advantage of Appx quick restructuring.