We have a powerserver mobile project that use SQLite3 as a local DB. The tables has decimal datatype columns but when we create a new DW with that tables as a datasource the PB recognize that columns as a WVARCHAR and we can't use these columns as numeric/decimal for example in edit masks and aritmeticals functions. I tried numeric datatype but with the same problem. Is it a bug? Do you have any idea how to make PB recognize the datatypes correctly?
PB 2019 build 2082 - Universal Edition