Skip to main content

I use the Trasfer data action to populate some Data Labels.  I want to create a button that can clear them out.  Is there a null value? 


I have in my notes from training that scnull is a K2 version of null, but I've never gotten that to work in black pearl, let alone smartforms.


 

Hello,


I usually use the "Execute a method on a view: Clear" rule to clear my fields (including data labels). 


I suspect you could do the same with the transfer data rule - just check mark the fields you want to clear, but put nothing in the actual field.


SCNULL is how the SmartObject API passes NULL to SQL. So, if you want to set a SmartBox (or SQL Service Broker) field to NULL in SQL, you would pass SCNULL to the SmartObject input parameter. You can see this in the SmartObject tester tool if you click the "Null" button next to one of your input fields.


HTH,


Tyler


Hey! Thats what those check boxes are for.


That did it.  Thanks Tyler.


 


Reply