Skip to main content


 

Symptoms


Rules were not executing due to the Database not being updated with the parameter type.

Forms

Create a parameter of type boolean.
Create a Text box.
Create a button
On button click - Transfer data from text box to parameter(not needed even by just chaning the default value of the boolean parameter gives the same results)

Create a sql table with a column of bit type.

On Button click (after the transfer data) transfer the Boolean parameter to the Bit Type colum.

In IE this does not work, it doesnt update the Bit column. Tested with True, False, 0 and 1 values.

Firefox works fine, Chrome works fine. IE doesnt
 

Diagnoses


We found that the issue was lying with the Parameters not being passed through to the database correctly. If we used Labels instead of the parameters it worked fine.

We then found that this was due to the usage of Boolean types in the parameter. When using Text everything works fine.
IE using Text and value True or False, or use Number type and values 1 and 0.

 

Resolution

This issue has been logged with our labs team as a bug. As a workaround, can you change the Parameter type from Boolean to Text.

According to my simple tests. The Values True and False are still interpreted correctly and should work.
If you use 1 and 0, try using Number as the Type.




 
Be the first to reply!

Reply