Member Avatar for 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?

  • 2 Contributors
  • 2 Replies
  • 108 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by carrieathomer
Member Avatar for 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.

Member Avatar for 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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.