469,623 Members | 968 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,623 developers. It's quick & easy.

Error Message about column not allowing nulls

I am writing a program using visual basic.NET 2003 to be used to update and store data in a database I have stored in Access 2003. I am using a OdbcDataAdapter to generate my dataset, then using a form as my data entry.

Every time I go to add a new record to my dataset to save to my Table, I receive this error message... 'An unhandled exception has occurred in your application ... Column "FP" does not allow nulls.'

Now FP is a column in my table where this information I am entering will be stored, however in access the columns properties are not required. The column is type Boolean. Essentially, the reason why is not required is bc it is a classification and there are 2 other choices to pick from all of which are not required either in my access table.

This happens every time I go to add a New Record then either when I tab all the way through to the end of my fields on my form or hit save.

The code I am using is:
' New Button
DataGrid1.CurrentRowIndex =DataView1.Count

OdbcDataAdapter1.Update(DataSet11.tbl_field_report )

Now I am not even sure if that code is appropriate or functions since I cannot get past this error message. If anyone has any knowledge on this error it would be greatly appreciated.

Thanks so much.
Jul 31 '07 #1
0 964

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Shervin Shapourian | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.