Right, thanks!

>Hello,
>
>it will but the results you'll get aren't what you are expecting ..
>
>since FoxPro can't handle out of it's own what records to update on a cursor that was created from a SQL with a JOIN in it .. (it probably will generate some UPDATE statements .. but these are normally semantically wrong)
>
>TABLEUPDATE will trigger the update progress of the CursorAdapter ...
>
>just test it out, write a CA with a JOIN in it's SelectCmd.. overwrite it's BeforeUpdate statement with
>
>BeforeUpdate(..)
>&& log SQL update statement to table with STRTOFILE or
>&& just "?" print it to the screen
>&& to examine what statements are created ..
>
>get some records with CursorFill ..
>change some fields in more than one row (BufferMode has to be 5 for this ..)
>?TABLEUPDATE(.F.,.F.,yourCA.Alias)
>
>Regards
>Christian