Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved 3 state checkbox on DW

  1. How-to
0
Votes
Undo
  1. Tracy Lamb
    Tracy Lamb
  2. PowerBuilder
  3. Wednesday, 19 September 2018 14:32 PM UTC

Usually, my dw checkbox edit style has  data value 'T' for ON and  'F' for OFF.  I've recently been asked to add a 3rd state that sets the database value to NULL.  What do I put for a value?

I changed the 3rd state edit style value to SetNull().  This worked in one dw yesterday (I thought).  So today I'm screaming through my code to edit the other dw's that are affected.  On the very first one, I'm getting an error: checkbox1 does not pass validation test

I get the same problem if I just leave ithe 3rd state data value alone, it defaults to 0 I think.

Any ideas what may be going on here and how I can set the value to NULL for the 3rd state?

TIA,

Tracy

customize the Appeon mobile LDAP Login screen
Issue with InsertRow function in PB2017 R3
Responses (2)
Philippe PILAT
Philippe PILAT Accepted Answer Pending Moderation
  1. Wednesday, 19 September 2018 15:15 PM UTC
  2. PowerBuilder
  3. # 1

Tracy,

maybe you have code somewhere to validate content of the column not allowing null value ?

I've done a simple test with a DW that has a column with a 3-state checkbox and a button.

Script in the button clicked event :


STRING ls_null
SetNull(ls_null)

CHOOSE CASE dw_1.GetItemString(1, "state")
 CASE "T"
  dw_1.SetItem(1, "state", "F")
  
 CASE "F"
  dw_1.SetItem(1, "state", ls_null)
  
 CASE ELSE
  dw_1.SetItem(1, "state", "T")
  
END CHOOSE
  

No validation error generated ...

 

Regards, Philippe.

Comment
Tracy Lamb
  1. Tracy Lamb
  2. Wednesday, 19 September 2018 16:12 PM UTC
Stupid question, but where is the Required property for columns set? I'm not finding it anywhere in the DW painter.
  1. Helpful
There are no comments made yet.
Philippe PILAT
Philippe PILAT Accepted Answer Pending Moderation
  1. Wednesday, 19 September 2018 14:51 PM UTC
  2. PowerBuilder
  3. # 2

Hi Tracy,

use null! for Other state

 

HTH.

Regards, Philippe.

Comment
Tracy Lamb
  1. Tracy Lamb
  2. Wednesday, 19 September 2018 14:59 PM UTC
I tried that, too. It's fine in the DW painter. But then during runtime, I get the same error when I try to change the checkbox state: CheckBox1 does not pass the validation test.
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.