>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,

You can use numeric index or Unicode encoded field name (case is important as well). Use STRCONV function to encode name in Unicode.

Thanks,
Aleksey.


>>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