Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Site Related Forums  Article Discussion  Insertion of NEW rec thru Merge Replication on PDA

Author  Topic  mandar Starting Member 2 Posts Posted - 2005-06-21 : 06:33:30 Respected Sir/Mam, I'm developing a application on Pocket Pc emulator by using Merge replication to synchronize the database. Database synchronization works totally fine in both the directions i.e frm Pocket PC -> Local Database & vice versa. But when i try to insert a new record, i get the error as follows... "A duplicate value cannot be inserted into Unique index..." when i execute the SAME query in Ms SQL it works fine....But the same query gives error in Compact Environment. When i searched on Net, I got one solution But it also did not work w.r.t my application. it suggested...Delete the index column and then get the snapshot of the database... But my index are generated with respect to PRIMARY Key column and thats why Ms SQL denies to delete indexes. Thus, I hereby request You to suggest me something which i can implement. Regards, Mandar C Jambotkar, Agrofoyer Solutions Pvt. Ltd., India