Invalid Data Error when editing application basing on JSDO

Posted by marekk on 06-Jan-2016 11:41

Hi,

I have created a simple Rollbase app where data comes from OE database thru JSDO external object.

Data is displayed correctly but when I enter the Edit mode, numerical data cannot be saved (even if I don't change them).

The error appears: Invalid Data, and below the field:
Error: Illegal character " "

The data is displayed with spaces and here is the issue, I guess.

How to resolve the issue? Can it be done globally, or for every field the appropriate function must be defined?


marek

All Replies

Posted by Anoop Premachandran on 07-Jan-2016 05:03

Can you give few details ?

What is the version of Rollbase you are using ?

what is the field type of this field in Rollbase ?

Looks likes it should be Currency or Integer or Decimal.

Please check the format of currency field if you have modelled it that way.

We do support setting space as separator and , as decimal separator.

Please try New UI that is available in version 4.0 and upwards.

Posted by marekk on 07-Jan-2016 15:36

Hi. The Rollbase is 3.2.3.0.

Yes, the issues are with numerical fields.

I created simple views basing on OE Service (JSDO - customer table in ProDataSet).

Pls take a look at the CreditLimit field properties.

-marek

Posted by Manooj Murali on 08-Jan-2016 07:26

Can you please let us know if you have any localization settings set ? (You can check by going to the setup -> My Localization Settings (or) setup-> Localization Settings page)

Regards

Posted by marekk on 08-Jan-2016 09:24

Sure. Here you are.

Regards,

marek

Posted by marekk on 10-Jan-2016 14:27

Thank you, for your advise.

I changed number format to any other and it works!

Moreover, I returned to original settings and works as well.

This thread is closed