Solved

cannot insert rows into Pulled table (RDA)

Posted on 2011-03-09
2
370 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Once again I push the limits of my phone.  An introduction to the Android Google Now Launcher.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

710 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