RE: Error: 0x80040e2f BD_INTEGRITYVIOLATION

[Kevin Boske - [MS]]

Do you have a Unique Index on this column?


Kevin Boske
([email protected])
SQL Server CE Team
Microsoft
----------------------------------------------------------------------------
----------------------------------------
Everything you need to know about SQL Server CE:

http://www.microsoft.com/sql/ce/techinfo/default.asp
----------------------------------------------------------------------------
----------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
----------------------------------------------------------------------------
----------------------------------------
--------------------
Content-Class: urn:content-classes:message
From: "Butt Chin Chuan" <[email protected]>
Sender: "Butt Chin Chuan" <[email protected]>
Subject: Error: 0x80040e2f BD_INTEGRITYVIOLATION
Date: Fri, 11 Jul 2003 08:01:25 -0700
Lines: 20
Message-ID: <[email protected]>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Thread-Index: AcNHvUxCxpHwEUy2QxeSLcAopElhqg==
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Newsgroups: microsoft.public.dotnet.framework.compactframework
Path: cpmsftngxa06.phx.gbl
Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.compactframework:28001
NNTP-Posting-Host: TK2MSFTNGXA13 10.40.1.165
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

I encountered the following error message:
Error: 0x80040e2f BD_INTEGRITYVIOLATION
NativeError: (25016)
Description: A duplicate value cannot be inserted into a
unique index [,,,,,]
Interface defining error: IID_IRowsetChange
Param. O:0
Param. 1:0
Param. 2:0
Param. 3:
Param. 4:
Param. 5:

I set my primary as auto-increment, not included in the
sql statement. The problem is this: If I enter the same
MemberID as the one in the previous record, I will get
this error message. I didn't set my MemberID as my primary
key, so why this error? Any suggestions? Thank you.

 

[Chin Chuan Butt]

No, I didn't set it as a unique index or something. I use ID as my
primary key, and other fields as nvarchar 50 (null allowed). My problem
is also discussed here, but no solution yet:
http://forums.devbuzz.com/tm.asp?m=24355&p=1&tmode=1&smode=1 (titled
Unable to insert record, unknown sql...)

Any idea why this problem crops up? It has been a week and i could do
nothing to it since the syntax is obviously correct (I tested it using
sql query analyzer in SQL 2000, it works, but not in PPC2002, whether in
vb.net application or sql query analyzer).

Thank you very much.

Butt Chin Chuan
A beginner in .Net Compact Framework development

 

[Kevin Boske - [MS]]

Can you post the SQL Statement to create the table and the statement you
run that causes this error?


Kevin Boske
([email protected])
SQL Server CE Team
Microsoft
----------------------------------------------------------------------------
----------------------------------------
Everything you need to know about SQL Server CE:

http://www.microsoft.com/sql/ce/techinfo/default.asp
----------------------------------------------------------------------------
----------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
----------------------------------------------------------------------------
----------------------------------------
--------------------
From: Chin Chuan Butt <[email protected]>
References: <[email protected]>
X-Newsreader: AspNNTP 1.50 (ActionJackson.com)
Subject: RE: Error: 0x80040e2f BD_INTEGRITYVIOLATION
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Message-ID: <#[email protected]>
Newsgroups: microsoft.public.dotnet.framework.compactframework
Date: Thu, 17 Jul 2003 05:50:27 -0700
NNTP-Posting-Host: actionjackson133.dsl.frii.net 216.17.147.133
Lines: 1
Path:
cpmsftngxa06.phx.gbl!TK2MSFTNGXA06.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP0
8.phx.gbl!TK2MSFTNGP12.phx.gbl
Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.compactframework:28460
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

No, I didn't set it as a unique index or something. I use ID as my
primary key, and other fields as nvarchar 50 (null allowed). My problem
is also discussed here, but no solution yet:
http://forums.devbuzz.com/tm.asp?m=24355&p=1&tmode=1&smode=1 (titled
Unable to insert record, unknown sql...)

Any idea why this problem crops up? It has been a week and i could do
nothing to it since the syntax is obviously correct (I tested it using
sql query analyzer in SQL 2000, it works, but not in PPC2002, whether in
vb.net application or sql query analyzer).

Thank you very much.

Butt Chin Chuan
A beginner in .Net Compact Framework development