From VFP7 help, XMLUPDATEGRAM( ) Function, Remarks:

You should specify the key field list by issuing CursorSetProp( ) with a KeyFieldList clause against existing cursors and tables before issuing XMLUpdateGram( ). If you specify no key fields, both before and after representations will contain all the fields in the table. If you specify one or more key fields, only those fields will appear in the 'before' section. Use the CursorSetProp( ) function to avoid possible errors generated by XMLUpdateGram( ) on tables containing Memo or General fields.


Even if the KeyFieldList is set to the appropriate key field(s), the modified fields still appear in the 'before' section of the updategram, not just those specified in the KeyFieldList.

Since the WhereType property can only be set for view cursors, perhaps the line above should be updated to read:

If you specify one or more key fields, only the key and modified fields will appear in the 'before' section when using cursors not based on views.


Change for a nickel anyone?

- Brian