...
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
#RUNQUERY SELECT 7 AS b, * FROM bid SELECT 8 AS b, * FROM bid SELECT 9 AS b, * FROM bid |
#FOREACH_IN
You can also define a foreach loop, e.g., as follows:
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
#LOOP x FOREACH_IN 1,2,...,9,10,20,...,60,90,120
/// Some content
#ENDLOOP
|
#IFDEF/#IFNDEF
With #IFDEF it is possible to check whether a variable exists and was set by #DEFINE or not. This is useful, for example, to run certain queries corresponding to the current setting. Use #IFNDEF for case where to check if a variable has no value
...
| Code Block |
|---|
#IF toInteger(CPU) > 1 #RUNQUERY ... #ENDIF ... #DEFINE a_string FOO #IF a_string == "FOO" ... #ENDIF |
#LOOP radius FOREACH_IN 5000,10000