cannot insert rows into Pulled table (RDA)
Posted on 2011-03-09
I've setup a RDA (Remote Data Access) connection between a PocketPC(Windows CE 5.0) and a SQL Server 2008 Express. Everything works fine (the Pull and the Push), but I can't insert rows into the tables in the SQL Mobile 3.5 database. Pulled tables have Identity rows and Primary keys on the Identity row. I can update and delete rows, but when I try to insert, it give the following error: "A duplicate value cannot be inserted into a unique index. [Table name, Constraint name]"
Insert statement is: "INSERT INTO TB_prdModel(modDesc, catID) values ('test', 1)"
Table TB_prdModel have 3 rows: modID (PK, Identity), modDesc (nvarchar(100)), catID (int).
Anyone have an idea how to fix this please? thanks for your time and help