Decimal Symbol

If your country's regional settings is set to use a comma as a decimal symbol, ROBOTILL will automatically change the symbol to a dot within ROBOTILL itself. The change is just within the ROBOTILL environment and will not affect your other programs.

Normally you will not need to do anything when your regional setting is set to use a comma as a decimal symbol. However, in the following cases it can still cause problems:

Problems related to the decimal symbol

Fewer columns in the Insert Statement Error

When you receive the following error message:

'There are fewer columns in the insert statement than values specified in the values clause. The number of values in the values clause must match the number of columns specified in the insert statement'

It means that the automatic change of the decimal symbol that should have occurred failed for some reason. The change only fails on some computers (at this stage we have not been able to determine why it fails on some computers). It is however not a problem as you can apply the fix described below.

Invalid number of columns during bulk import

Some spreadsheet programs like OpenOffice will also automatically change a comma to a dot as a decimal symbol when exporting to CSV - others like Excel might however use the comma as a decimal separator. This will cause problems as the file is a comma separated file.

Solution - Change your decimal symbol to a dot

Go to your Windows Control Panel.
In Windows 10 simply type 'Control' in your Windows search bar.
In Windows 7 click on Start > Control Panel.

In your Control Panel, go to Regional Settings or 'Region'

Click on 'Additional Settings'.

Change your decimal symbol to a dot. Do the same for your decimal symbol in the Currency tab. Click on OK.

If the program with the problem is open, close and open it again so that the new settings can be loaded and used.