Null Error

  • Thread starter Thread starter Erik
  • Start date Start date
E

Erik

I have a Windows form that does a insert and then a update to a dataset.
When I do the insert/update and all the fields are filled in it works fine.
But when there is a null value or when the field is empty I get the usual
update error.
I'm using a Access database and none of the fields are required.
I don't want to have to make a seperate object to merge the changes like
most of my forms do.
VB6 had shortcuts and I would like to use one in VB.NET

I want to have a If Then Else or something to use as a shortcut around this.
Like:
If textbox1 = NULL then
skip
Else
Add textbox1.text = recordset.....

I have found limited info on the Null field problem. Something like
System.DBNULL
In the old way I would do something like a IIF(NULL) etc...

Does anybody have any ideas.

Thanks.

Erik
 
Back
Top