Specifies the decimal separator setting used by the back-end DBMS that you are accessing in DataWindow Designer. If your DBMS uses a decimal separator other than period (.), which is the default, set DecimalSeparator to the value for your DBMS to ensure that DataWindow Designer correctly handles numeric strings returned from your database.
ADO.NET
DIR Sybase DirectConnect
ODBC (if driver and back-end DBMS support this feature)
OLE DB
O84 Oracle 8.x and Oracle8i
O90 Oracle9i
O10 Oracle 10g
DecimalSeparator = 'value'
DecimalSeparator = '.'
When to set DecimalSeparator The DecimalSeparator parameter currently supports period (.)
and comma (,) as valid values. Therefore, if the decimal separator
setting for your DBMS is a comma, you should set the DecimalSeparator
parameter to '
,'
(comma)
to make sure DataWindow Designer correctly handles numeric strings returned
from your database.
Example using Oracle Assume you are accessing an Oracle database in DataWindow Designer and the decimal separator setting is a comma (,). Oracle returns to DataWindow Designer the numeric string '123,50' containing a comma instead of a period as the decimal separator. DataWindow Designer then sends this string to its decimal conversion routines.
By default, the DataWindow Designer decimal conversion routines expect
a period as the decimal separator. If you set the DecimalSeparator
parameter to '
,'
(comma), DataWindow Designer correctly
handles this string and returns it as '
123,50'
.
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.
Application Type the following in code:
SQLCA.DbParameter = "DecimalSeparator=','"