Hi Sylvain

The situation is simple I have to integrate and existing application with a third party software. They need to know when an item has been deleted so that they can mark the item as such in their system and have it displayed differently from none deleted items. This requires that they received deleted and non-deleted records. I do not wish to re-write the application so it flags deleted records in some special way just so I can integrate it with third party software occasionally. So the easiest way is to send all the items deleted or not deleted so they can process the items as necessary.

Since the XMLToCursor does not flag deleted records I had to create a custom XML export to achieve this result.

Regards,
Simon


>I wonder why you would want to send deleted records in the XML file. If it's for sending transactions on the table (records deleted), you could acheive this by adding a transaction field in the table.
>
>>It appears to me that there is no way to tell if a record was deleted in the original table if you use CursorToXML and then recreate the table from the XML file with XMLToCursor.
>>
>>It would be nice if the CursorToXML/XMLToCursor functions also handled deleted records so that the cursor created from the XML file also contained the deleted records and they were marked as deleted. At present you could included deleted records in the XML file but they would not appear deleted in the cursor created from the XML file so you actually lose information in the transfer.