Hi,
I need some help, pls... I been looking at this problem but i could not find the source. Here's the scenario.
When I first deploy my application to my mobile device using VS2008 and do the synchronization, it works okay. My two tables(table 1 and 2) gets updated with the lastest changed(updated/inserted/deleted). At this time my .sdf file and my sql server 2005 is in-sync. But after a minute, I changed one record on server for table 1 and try to synchronize again, this time it said that i have downloaded 1 update, but I could not see the changes for that record. It seems that is not updating that record. But If I do that on table 2 and re-sync, it works okay on both ways!!
I used bidirection for both tables, i have LastEditDate and CreationDate and I also specify, clientwins if clientupdateserverupdate. In my localdatabasecache, i selected, UseExistingTableOrFail.
Now, another problem comes up, if I update the record in the client and do a re-sync, it overwrite the changed i did on server.
BTW, im using SQL Compact 3.5 and SQL Server 2005 and windows mobile 6.1 professional.
Let me know if you need more info..
Thank you in advance.
