Hi Aleksey,

Thanks for your solution, it works now.

What is the easiest way to refer to the XMLField collection?

I got "Index or expression does not match an existing member of the collection. (Error 2061)" when try to refer it as xmlfield("field_name") or xmlfield.item("field_name").

Currently I have to use FOR EACH command

Cheers,
David

>Hi David,
>
>There is a limit on command length.
>XMLAdapter.ApplyDiffgram uses CursorAdapter to do the actual work. >CursorAdapter generates SQL statements to update the base table. One part >of default setup for CursorAdapter object in XMLAdapter.ApplyDiffgram >method is "If the KeyFieldList property is empty, Visual FoxPro adds key >fields only if specified (by XMLField.KeyField property). Otherwise, Visual >FoxPro adds all fields.".
>Can you imagine how long a WHERE clause when 79 fields are listed there?
>
>Try to mark key fields with XMLField.KeyField property. Does it solve the >problem?

>Thanks,
>Aleksey.


>>Dear all,
>>
>>I having a problem when using the xmladaper.applydiffgram() method.
>>
>>I always get an error #18, Line is too long.
>>
>>My table has 79 fields (total 1163 bytes).
>>
>>When I use different table (49 fields, total 755 bytes), I got error #1812, SQL: Statement too long.
>>
>>Is there a limitation with applydiffgram method?
>>
>>Thanks in advance,
>>David