Insert Record Fails W/ Unique Constraint

		Wrox Programmer Forums > C# and C > C# 1.0 > C#
Insert Record Fails W/ Unique Constraint

C# Programming questions specific to the Microsoft C# language. See also the forum Beginning Visual C# to discuss that specific Wrox book and code.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the C# section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

September 2nd, 2005, 02:14 PM

snw

Registered User

Join Date: Aug 2005

Posts: 2

Thanks: 0

Thanked 0 Times in 0 Posts

Insert Record Fails W/ Unique Constraint

Hi,

I keep getting an error when I try to insert a new record into a table (SQL 2000) that has a column that I've configured as 'Unique Null Allowed'. I used Visual Studio (2003) IDE SQL Data Adapter Wizard to create the stored procedures, data adapter, and dataset using a simple select statement with one paramater. Everything works fine except the 'Unique Null Allowed' column requires a value on Insert or I get an error. What am I doing wrong?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Why not using a unique constraint in ch 5?	asptwodev	BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6	2	September 20th, 2007 09:25 AM
insert fails	Mitch	MySQL	3	June 3rd, 2006 11:48 AM
Unique Record Identifier	peace	Access VBA	1	December 6th, 2005 12:03 PM
Counting unique record	dlamarche	Access	5	March 22nd, 2005 08:51 AM
duplicate nulls in a column with unique constraint	defiant	SQL Server 2000	3	October 22nd, 2003 01:58 AM