Posted - 06/21/2005 : 06:33:30
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.
Mandar C Jambotkar,
Agrofoyer Solutions Pvt. Ltd.,