locked
How am I doing for treat conflict the data? RRS feed

  • Question

  •  
    Hello

    I have a question about how to handle conflicts.

    I have two tables:

    PRODUCT:

    IDPRODUCT NUMERIC (10) PK,
    PRODUCTNAME VARCHAR (40)


    PRODUCTSELLER:
    IDSELLER NUMERIC (10) PK,
    IDPRODUTO NUMERIC (10) PK


    Table PRODUCTSELLER Saved products that the seller sells


    The seller sells the product wafer, or the client have that information in two tables.


    We assume that someone in the server delete the product wafer.

    How the client to delete the record from both tables?.

    Can anyone help?

    Thanks

    Marcos Antonio Aguiar Jr
    • Moved by Hengzhe Li Friday, April 22, 2011 5:38 AM (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Friday, February 13, 2009 1:29 PM

All replies

  • I assume there is a FK relationship between those two tables where the productSeller has the FK. what is the "on delete" action for this FK ?

    A couple of things need to be considered for tables as that: 1. the delete action on both server and client 2. order of tables in the syncagent.configuration.syncTables collection which controls the order for tables to be changed. 3. the fact that sync server treat "delete-delete" conflict as no action.

    hope this can clear your doubts.

    thanks

    Yunwen


    This posting is provided "AS IS" with no warranties, and confers no rights.
    Monday, February 16, 2009 9:27 PM
    Moderator
  • Hi Yunwen.

    I don't know the event ApplyChangeFailed, but now I learn with use, but I don't know how I will doing to treat exception. Would I like that when the event ApplyChangeFailed is called the message error is show and a rollback is execute.

    Do you know how to do?

    Marcos Antonio Aguiar Jr
    Tuesday, February 17, 2009 12:25 PM