DBDecimalChar

Valid in all scopes

The value of this configuration variable tells Tango Server what decimal character ODBC data sources require in numbers. This value may be determined by the ODBC driver, the database vendor's client software, or the DBMS server. You must make sure you set this configuration variable appropriately for the ODBC data sources you are accessing with Tango Server.

If you use ODBC data sources requiring different decimal characters, you may use the DBDecimalChar with scope=LOCAL to change this setting temporarily while accessing a specific data source.

The setting of DBDecimalChar is used when Tango Server is constructing SQL for Search, Insert, Update, and Delete actions that use ODBC data sources. If necessary--for example, when DBDecimalChar differs from decimalChar--Tango automatically converts values specified for numeric columns to use the decimal character specified in DBDecimalChar. Use the <@DSNUM> meta tag to perform the same function on numbers you specify in Direct DBMS actions using an ODBC data source.

The default value of DBDecimalChar is a period (".").

See Also

currencyChar
decimalChar
thousandsChar
<@DSDATE>, <@DSTIME>, <@DSTIMESTAMP>
<@DSNUM>