In the case of JOINed tables, tableupdate() will not handle
saving changes to base tables automatically?

>Hello,
>
>1. no, if you set all necessary properties FoxPro is able to produce this statement automatically for you ..
>
>excerpt from VFP9 help on Cursoradapter:
>"When the CursorAdapter InsertCmd, UpdateCmd, and DeleteCmd properties are empty, Visual FoxPro generates the corresponding SQL commands automatically. You must determine whether automatic generation of these commands is appropriate for the data source you are using. To generate the SQL INSERT, UPDATE, and DELETE commands automatically, you must set the following CursorAdapter-specific properties:
>-Tables
>-KeyFieldList
>-UpdatableFieldList
>-UpdateNameList"
>
>also look at these properties which have influence on what type of SQL statement is generated:
>-WhereType
>
>to resolve data update conflicts look at these properties
>-ConflictCheckType
>-ConflictCheckCmd
>
>2. yes, but this would involve custom coding on your side ..
>since a left join can produce more than one record for the driving table you'll have to determine somehow which of these records to update ..
>
>you can overwrite the BeforeInsert, BeforeUpdate, BeforeDelete events of the CA and create the neccessary SQL statement's there manually
>
>Regards
>Christian