Beas determines whether the parameter is a number or a string depending on the value.
•If the value is a number or "0", Beas interprets this parameter as a number.
•If the value is empty or not a number, Beas interprets this parameter as a string.
Example 1:
Parameter: "color" is "red"
Formula: 'the color is ' || [color]
HANA SQL: select 'the color is' || 'red' -> all ok
Formula: 10 + [color]
SQL: 10 + 'red' -> produce error
Example 2:
Parameter: "color" is "5.3"
Formula: 'the color is ' || [color]
HANA SQL: select 'the color is' || 5.3 -> produce error
Formula: 10 + [color]
SQL: 10 + 5.3 -> all ok
The evaluation of a formula is always dependent on the contents of the parameter.
All configurations created with beas 9.2 PL 5 Build 32 or older, use parameter type "Auto" as standard.
Working with Beas system variables or custom defined variables starting with "e_", the parameter can be interpreted as a string or number. With the following BeasScript setup the type can be permanently defined as string type, if the value is a Beas variable. This must be executed only once per database or client.
setsetup=config_default_e_type=c
|