# Tabel View: can insert null values into not nullable columns

**URL:** <https://forum.servoy.com/t/tabel-view-can-insert-null-values-into-not-nullable-columns/3386>\
**Category:** Classic Servoy\
**Created:** [January 6, 2005, 8:29am UTC](https://forum.servoy.com/t/tabel-view-can-insert-null-values-into-not-nullable-columns/3386 "2005-01-06T08:29:15Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![pbakker](https://avatars.discourse-cdn.com/v4/letter/p/a4c791/32.png) [@pbakker](https://forum.servoy.com/u/pbakker)\
**Post date:** [January 6, 2005, 8:29am UTC](https://forum.servoy.com/t/tabel-view-can-insert-null-values-into-not-nullable-columns/3386/1 "2005-01-06T08:29:15Z")

</div>

Hi,

Working on sybase, I have a form in Table view. The form is showing all the columns of the underlying table.

When I create a new record and do not fill any data in some of the fields that are defined in the DB (and in Servoy the Dataprovider Editor also says it) as not nullable, I am able to save the record, without problems.

How can this be? somehow, I would expect the DB to give an error, but it doesn’t…

Paul

Puzzled…

---

<div class="post-metadata">

**Author:** ![pbakker](https://avatars.discourse-cdn.com/v4/letter/p/a4c791/32.png) [@pbakker](https://forum.servoy.com/u/pbakker)\
**Post date:** [January 6, 2005, 4:35pm UTC](https://forum.servoy.com/t/tabel-view-can-insert-null-values-into-not-nullable-columns/3386/2 "2005-01-06T16:35:55Z")

</div>

Ok, never mind… ![:D]( "Very Happy")

Seems that either Servoy, or Java, or Sybase inserts a emtpy string into the field…

Paul