brDecimal property

Sets or returns the decimal separator.

Note: See the Remarks section for RPC and ODBC connection exceptions.

Syntax

object.brDecimal[ = sValue]

Parameters

Parameter Description
object An object variable that represents an object in the Applies To list.
sValue The setting or return value is a String data type indicating the decimal separator character.

Remarks

  • Using an RPC connection, the decimal separator is set on the client workstation.

  • Using an ODBC connection, the decimal separator is set on the server.

Example

Sub Main()
   Dim oEnv As New clsD3Environment
   Dim oConn1 As clsD3Connection
   Dim oConn2 As clsD3Connection
 
   ' Environment settings.
   oEnv.brCurrency = "$"
   oEnv.brDecimal= "."
   oEnv.brGrouping = ","
   oEnv.brCasing = False
 
   ' oConn1 will inherit environment settings.
   Set oConn1 = oEnv.brOpenConnection("ODBC", "USproduction")
   Set oConn2 = oEnv.brOpenConnection("ODBC", "UKproduction")
 
   ' Customizing settings.
   oConn2.brCurrency = "L"
   oConn2.brDecimal= ","
   oConn2.brGrouping = "."
 
   ...
 
   ' Closing connections.
   oEnv.brCloseConnection oConn1
   oEnv.brCloseConnection oConn2
   Set oEnv = Nothing
End Sub

TCL reference

set-num-format