# allow null in data provider

**URL:** <https://forum.servoy.com/t/allow-null-in-data-provider/1639>\
**Category:** Classic Servoy\
**Created:** [April 5, 2004, 1:43pm UTC](https://forum.servoy.com/t/allow-null-in-data-provider/1639 "2004-04-05T13:43:37Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![gul\_irfan](https://avatars.discourse-cdn.com/v4/letter/g/848f3c/32.png) [@gul\_irfan](https://forum.servoy.com/u/gul_irfan)\
**Post date:** [April 5, 2004, 1:43pm UTC](https://forum.servoy.com/t/allow-null-in-data-provider/1639/1 "2004-04-05T13:43:37Z")

</div>

I’m not quite sure where to ask this, sorry if wrong forum.  
When I created a field in my dataprovider, I didn’t check out the ‘allow null’ checkbox, now I cannot change it.  
Can I do something with it?

---

<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:** [April 5, 2004, 2:03pm UTC](https://forum.servoy.com/t/allow-null-in-data-provider/1639/2 "2004-04-05T14:03:17Z")

</div>

Once the colum is created, you cannot change such properties, because if there is allready data in the table, there might be a conflict with the new setting.

Your only option is to change it through a DB admin tool.

I think Servoy is looking into offering this option through Servoy (there is another post on the forum regarding this item, with more explanation from Servoy)

Paul

---

<div class="post-metadata">

**Author:** ![IT2Be](https://avatars.discourse-cdn.com/v4/letter/i/dc4da7/32.png) [@IT2Be](https://forum.servoy.com/u/IT2Be)\
**Post date:** [April 5, 2004, 2:04pm UTC](https://forum.servoy.com/t/allow-null-in-data-provider/1639/3 "2004-04-05T14:04:04Z")

</div>

Nope, this is the way it is. You can’t change it from within Servoy.