Inserting empty values in SQL TABLE that has allow no nulls

[carrieathomer]

Hi

here is the scenario.

I am using Form View to insert data to the table.

My table is MS sql server table of which all the columns are allow no nulls

However, sometimes i need to empty values ie no value to the table column.

Is it possible?

[nakor77]

can you insert a null value into a column that doesn't allow nulls? I would guess not. You could possibly create some default value to insert that isn't likely to be a value chosen/used by whoever is filling out the form.

[carrieathomer]

Ok I will explain again

I want to insert empty value not null value.

empty value can be string empty.

In the formview there is a text field let's say a description text box. But it is not required to insert any value in it.

So when inserting data in the form view, I get the error cannot insert null value in the coloumn description.

The issue is I am using Formview directly.