PROBLEM

When using the ActiveX connector with different locales, numbers are truncated

Last Published: April 25, 2020

Description

When I use the ActiveX connector with different locales, numbers are truncated.

Cause

You are using the ActiveX connector with locales that have different decimal separators like "."(periods) or ","(commas).

The Cdbl() function is capable of handling different decimal separators for different locales; if the correct decimal separator is not used, the numbers might get truncated and lead to undesirable results.

Solution or Workaround

While using whole numbers inside the Cdbl() function, the decimal separator should conform to the decimal separator of the locale.

    Article ID:000003675

    Software:
    • Legacy Products

    Receive notifications and find solutions for new or common issues

    Get summarized answers and video solutions from our new AI chatbot.

    Download the Esri Support App

    Discover more on this topic

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options