I have eight columns in table tbl_tanker of SQL length breadth the depth draft LBratio LDratio Bdratio Ddratio
Before I have finished four columns of input data forward, now want to only add data in four columns back!
My code is written, prompt column length cannot be null, I don't want to addnew bring the former four columns, how do you write the code?
The great spirit guide genuflect is begged!

CodePudding user response:

It is not prompt you to length columns cannot have a NULL value,
1, modify the length column under the constraint conditions, to allow inserting NULL values
2 in VB, we gave the length column a default value of 0 (meaningless, it is no value indicating the length)

CodePudding user response:

Behind the front four already has data, four columns is not should use the update, how to use the addnew?

After the update to update the content of the four columns, addnew increase record again, in front of the four columns are empty,

CodePudding user response:

Try removing. AddNew statement,

CodePudding user response:

This tip is not already very clear, some you don't have the selected field does not allow null values.

And this is the "line", don't call.

CodePudding user response:

This should be database constraints don't you accept Null values, like the VB code is no problem