currencyChar

Valid in all scopes

(local scope invalid when staticNumericChars=true)

The value of this configuration variable tells Tango Server what character string is used as the currency symbol in money values (for example, in the USA and Canada, the dollar sign ($) is used). Values up to three characters in length may be assigned to currencyChar. If a longer value is assigned, only the first three characters are used.

Tango Server uses this value in order to properly evaluate numbers in conditional comparisons (for example, Branch action, <@IF>, <@IFEQUAL> and <@ISNUM> meta tags) and in calculations performed with <@CALC>; that is, it recognizes that strings that start or end with these characters are to be treated as numeric and not text.

The setting is also used when Tango Server is constructing SQL for Search, Insert, Update, and Delete actions. Tango automatically removes the character string specified by currencyChar from any values specified for numeric columns. Use the <@DSNUM> meta tag to perform the same function on numbers you specify in Direct DBMS actions.

The default value of currencyChar is $.

currencyChar and Scope

For more information, see "staticNumericChars" .

When staticNumericChars has the value TRUE (the default), changing the value of currencyChar has no effect during the execution of an application file. Changes to currencyChar in user, domain, or system scope take effect with the next application file execution; as a consequence, changes to currencyChar in local scope have no effect.

See "Understanding Scope" in Chapter 7 of the User's Guide.

When staticNumericChars has the value FALSE, currencyChar works with scope in the standard way.

See Also

DBDecimalChar
decimalChar
<@DSDATE>, <@DSTIME>, <@DSTIMESTAMP>
<@DSNUM>
staticNumericChars
thousandsChar