We have a number of fields in a number of tables where the value can be either Y or NULL, don't ask me why its a legacy system and nobody can say why it wasn't Y or N or 1 or 0.

Anyhow, I don't appear to be able to set the unchecked value of the checkbox to NULL in FS, or am I missing something.

I know I can do something funky with our table API/trigger to translate from N to Null, but thought I would ask just in case.

asked 04 Aug '15, 06:02

apacheuk's gravatar image

accept rate: 0%

Hi Simon,

Unfortunately it's not possible to set the unchecked value of the checkBox to NULL, you can only set the unchecked value to a not null string. As you mentioned, the only way to achieve this is to translate from N (or your custom not null value) to NULL.

Best Regards,


answered 04 Aug '15, 13:44

Ibrahim%20Sandalli's gravatar image

Ibrahim Sand... ♦♦
accept rate: 25%

OK, I figured as much.... made a start on changing our API's to handle this


answered 05 Aug '15, 02:22

apacheuk's gravatar image

accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 04 Aug '15, 06:02

Seen: 1,845 times

Last updated: 05 Aug '15, 02:22

© Copyright Gerger 2017