I'm tryng to create a checkbox pointing to a column that is NUMBER(1): 0 = false 1 = true, but i dont' see never in the screen (only the check box... but i don't see che value checked for 1 e unchecked for 0) Is it possible in FS? The few examples i found in documentation use Y/N varchar fileds... My example: <cell halign="Right" valign="Full"> <checkbox visible="Y" enable="Y" column="AUTH_FLAG" datasource="TAB_USERS1" checkedvalue="1" uncheckedvalue="0" checked="Y"/> </cell>

Can you help me please? Many thenks. Giuseppe

asked 02 Dec '14, 11:25

giuseppe_polo's gravatar image

accept rate: 0%

Hi Guiseppe,

I just tried an example. There is indeed a bug. The checkbox doesn't recognize the number 1 as being equal to its checked value even though it is 1. (This works correctly if the checkbox is inside the grid component).

There is one workaround. Open the datasource definition dialog your datasource is based on. Next, navigate to the column tab for AUTH_FLAG. Override its default datatype NUMBER with DefaultVarchar2. Now Formspider will treat the 1 and '1' and it will recognize it as being equal to your checkedValue 1.

I opened a ticket in our issue management system for this.

Kind Regards,


answered 03 Dec '14, 10:03

Yalim's gravatar image

Yalim ♦♦
accept rate: 20%

Good news!! Thank you very much Yalim. You are great!

(03 Dec '14, 10:36) giuseppe_polo
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: 02 Dec '14, 11:25

Seen: 1,588 times

Last updated: 03 Dec '14, 10:36

© Copyright Gerger 2017