Method:Classic General Q&A

Re: Retrieve NULL Value From an Action

Blake C — Thu, 08 Nov 2012 22:45:42 GMT

Yeah, that's exactly what I wound up doing. Seems weird, but it works

Re: Retrieve NULL Value From an Action

Method_Ashur — Thu, 08 Nov 2012 22:44:34 GMT

Forgot to mention that if you have the grid on your screen then add a Refresh Grid action after your end loop through table action.

Re: Retrieve NULL Value From an Action

Method_Ashur — Thu, 08 Nov 2012 22:40:28 GMT

Hi Blake,

The Loop Through Table/Grid actions are very useful and in this case you can set the condition to where "field" is not equal to, type in, and leave the text box blank. This will work as you want it to.

- Ashur

Re: Retrieve NULL Value From an Action

Blake C — Wed, 07 Nov 2012 23:06:59 GMT

BTW, I immediately thought of a workaround. I just loop through the table for the field I'm trying to get the value for and inside the loop assign the value to an action result. Knowing there will be only one record to possibly loop over affectively sets the value if one exists.

GOT to be a better way than this...what am I missing?

Retrieve NULL Value From an Action

Blake C — Wed, 07 Nov 2012 22:58:15 GMT

Is there any way I can check a value for NULL or empty prior to attempting to use it in an action?

I've customized my Item table by adding a couple fields. Most Item records will not have a value set for these new custom fields but if an Item does have a value I need to use it in a series of custom Actions. When I use the 'Retrieve Value From Table' action, an error occurs b/c there's no value set.

Does this make sense? How do I get around this? Is there something like an ISNULL check I can do from an Action?

Thx