Announcement

Collapse
No announcement yet.

Passing null value to database if the field or column is empty

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Passing null value to database if the field or column is empty

    Hello; I have a form application which I want to use in two different tab page by hidding some field but these hidden field must have null value when inserting or updating. The idea is to avoid to use two views but yet I've not hide the field if I try to leave the field empty and insert or update the database is sending a foreign key error which is not true.


    In the database the field is set to accept null value and is a foreign key. If I try inserting or update to the database using workbench and leaving the field to null everything is working but when I try from the form it is sending error.

    On my understanding it seems that the form application is sending a value which is an empty string but I would like it to take the field as database null value to send if the user doesn't type something. So how can I do that?

  • #2
    Go to Field Settings -> Section Database Value and chose what you need.

    jsb

    Comment

    Working...
    X