Changed to CompareMemo = .F. and that completely fixed the problem.

Yes, using "NATIVE" data source type with WhereType = 3 and yes, the auto-generated command is WAY too long.

Again, this is an extreme case due to the number of metadata memo fields.

As always Aleksey, thanks for your help. You da man...

>>No,
>>
>>The CA KeyFieldList is OK as well as all other CA properties. Also set the correct XMLField.KeyField property just in case.
>>
>>Could there be a problem with CompareMemo = .T. with 50 memo fields? I know that is an extreme number of memo fields - using them for metadata.
>>
>
>Are you using 'NATIVE' data source type for the CursorAdapter? The CompareMemo=.T. can be a problem, if all memo fields are added into the WHERE clause, the auto-generated command might exceed the limit. What WhereType are you using? You can check the length of auto-generated command in BeforeUpdate/BeforeDelete event and confirm if this is the case.
>
>
>>Also checked the DiffGram. Where are all the linefeeds (over 1,000) coming from? Is this creating the problem? Why does the XMLAdapter create linefeeds?
>>
>
>I am pretty sure this error is not related to the DiffGram size nor it is related to the linefeeds. The linefeeds inserted because XMLAdapter.FormattedOutput property is .T. by default.
>
>Thanks,
>Aleksey.