Solved

cannot insert rows into Pulled table (RDA)

Posted on 2011-03-09
2
367 Views
Last Modified: 2013-12-27
hello,

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

0
Comment
Question by:Dominic34
  • 2
2 Comments
 

Author Comment

by:Dominic34
ID: 35087200
seems the Identity value of the column is reset to 1 after the Pull. So, either I reset the Identity to the MAX value of all the tables or I change all my tables from INT Identity to GUID. What should I do?

GUID take a LOT more memory than INT and is a pain to work with (not really user-friendly). But INT Identity could cause problem when synchronizing with multiple clients.

What is the best way to sync tables using RDA ??
thanks
0
 

Accepted Solution

by:
Dominic34 earned 0 total points
ID: 35095976
Ok, I converted all INT Identity to GUID, now it works fine. thanks to myself for the answer.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Let me explain this picture a little bit.  First, in case you haven't already guessed, you are looking at my 2 phones, an Android Samsung Galaxy S5 on the left and an iPhone 5 on the right.  They are on their respective cradles on my desk.  But, you…
You should read OS supplied guidelines before developing. I can't stress that enough. The guidelines will help you understand the reasons mobile app developers do what they do.  Apple is very particular when they review appstore submissions.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now