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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement