Four Stars

Getting Started with tSetGlobalVar and tJavaRow components

I 'd like to count non empty fields of a column from a sql table
Question 1 : why , when i want to add tSetGlobalVar , the example is between quotes ? i only want to initialise a integer variable to 0.
Question 2 :
how add 1 to this variable when the field is not null ?
Question 3 : how display this variable ?
Thanks in advance
1 REPLY
Seven Stars

Re: Getting Started with tSetGlobalVar and tJavaRow components

1. If you mean the value example, because it's a string. You can put any expression you want there.
3. To retrieve, use the expression: (YourDataType)globalMap.get("YourVariableName") e.g. (Integer)globalMap.get("Counter")
2. For example: ((Integer)globalMap.get("Counter"))==null?1Smiley SadInteger)globalMap.get("Counter")+1