DecimalSeparator

Description

Specifies the decimal separator setting used by the back-end DBMS that you are accessing in PocketBuilder. If your DBMS uses a decimal separator other than a period (.), which is the default, set DecimalSeparator to the value for your DBMS to ensure that PocketBuilder correctly handles numeric strings returned from your database.

Applies to

ODBC

Syntax

DecimalSeparator = ‘value’

Parameter	Description
value	The decimal separator setting used by the back-end DBMS that you are accessing in PocketBuilder. Values are: '.' (Default) Specifies that your back-end DBMS uses a period (.) as the decimal separator. If you do not specify DecimalSeparator or if you specify a value other than period (.) or comma (,), PocketBuilder uses period (.) as the decimal separator. ',' Specifies that your back-end DBMS uses a comma (,) as the decimal separator.

Parameter

Description

value

The decimal separator setting used by the back-end DBMS that you are accessing in PocketBuilder. Values are:

'.' (Default) Specifies that your back-end DBMS uses a period (.) as the decimal separator. If you do not specify DecimalSeparator or if you specify a value other than period (.) or comma (,), PocketBuilder uses period (.) as the decimal separator.
',' Specifies that your back-end DBMS uses a comma (,) as the decimal separator.

Default

DecimalSeparator = ‘.’

Usage

When to set DecimalSeparator The DecimalSeparator DBParm currently supports a period (.) and a comma (,) as valid values. Therefore, if the decimal separator setting for your DBMS is a comma, you should set the DecimalSeparator DBParm to ',' (comma) to make sure PocketBuilder correctly handles numeric strings returned from your database.

Examples

Example 1

To specify that your DBMS uses a comma (,) as the decimal separator setting:

Database profile Type a comma (,) in the Decimal Separator box on the Syntax tab in the Database Profile Setup dialog box.
PocketBuilder application script Type the following in a PocketBuilder application script:
```
SQLCA.dbParm = "DecimalSeparator = ','"
```

DecimalSeparator

Description

Applies to

Syntax

Default

Usage

Examples

Example 1

See also