Hi Can someone help me with this error:<br><br>ODBC Error Code = 23000 (Integrity constraint violation)<br><br>[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'UserName', table 'PostYourHome.dbo.Sellers'; column does not allow nulls. INSERT fails.<br><br>I got this error when inserting a form data into SQL database. I have created all the seller details in "sellers" table and also has username filed in Sellers.<br>When i insert some data into sellers table , i get thsi error.<br>i basically want to know what this error means.<br><br>Thanks<br>Praveen<br><br>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Integrity constraint violation
- Thread starter potinenip
- Start date
SnakeHollywood
Programmer
It is self explanitory.<br><br>You are trying to insert a null value (no value) into the column USERNAME, which does not accept null values.<br><br>If it does not accept NULL values and you want it to accept null values then change the setting of this column to allow it, or make sure you do not try to insert null.<br><br> <p>Russ Michaels<br><a href=mailto:russ@satachi.com>russ@satachi.com</a><br><a href= Internet Development</a><br>For my personal book recommendations visit <br>
- Status