Multi Table Updates from Joins

ASTA supports multiple tables to be updated when using Cached EditMode. This is not supported

in AfterPost edit mode as a transaction is required for the possible multiple lines of SQL

generated for any one row.

To use the Multi Table Update Feature:

1. Write your SQL Join and set the AstaClientDataSet.Active property to true at design time

2. Use the edit mode property editor and click on the Multi Table Join Tab

3. Click on the Define fields for multiple table updates button

4. Choose an Update tablename for each field and tag the primekey fields.

Note: the Primekeys of all the update tables must be included in the Join as they will be

required for the SQL.