Sync 2 compact database files to one server RRS feed

  • Question

  • hi,

    In my Offline Mobile project ,I'm having same synchronized .sdf file in 2 PDAs. I'm updating ITEM1 in both PDAs. 

    my problem is, Finally when I sync back both these .sdf files to server, the item Qty needs to be added together.

    how to do this? please help me

    Wednesday, April 11, 2012 8:58 AM

All replies

  • the synching of PDA1 is totally independent of the PDA2 synching. PDA1 and PDA2 can sync in different times as well. So you can't do the manipulation during sync or inside Sync Framework.

    add an extra column such that you have ClientId+Itemid+Qty, then you can do a sum and group by ItemId on the server.

    Wednesday, April 11, 2012 9:58 AM