Insert Fails W/Unique Constraint

[rich_wenger]

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?

[Mohamad Al Husseiny]

If you have a column which is Unique and Allow nulls then only one record will be allowed to have null value in this columns because if other record was inserted with null value in this unique columns it will not be allowed because this column is unique and other record already have null value in this column MCAD -- modified at 20:54 Friday 2nd September, 2005