1. Marcos Bolonha
  2. PowerServer Mobile
  3. Friday, 22 November 2019 12:34 PM

Hi,

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

SQLite3

Marcos Bolonha Accepted Answer Pending Moderation
  1. Monday, 25 November 2019 13:24 PM
  2. PowerServer Mobile
  3. # 1
0
Votes
Undo

Hi Roland,

Thanks for your answer. To be honest I didn't try to add a section on pbodc*.ini. I decided uninstall de ODBC driver and install it again, and now it is working fine.

BR

Marcos

Comment
Great! Which driver are you using?
  1. Roland Smith
  2. Monday, 25 November 2019 14:17 PM
SQLite3 ODBC Driver - version 0.9996.00.00 by Cristian Werner Software and Consulting.



Marcos
  1. Marcos Bolonha
  2. Monday, 25 November 2019 14:30 PM
There are no comments made yet.
Roland Smith Accepted Answer Pending Moderation
  1. Friday, 22 November 2019 13:48 PM
  2. PowerServer Mobile
  3. # 2
0
Votes
Undo

I haven't tried it myself but I believe you have to add a section for SQLite to the pbodb***.ini file and use the SpecialDataTypes setting to assign the PB datatypes to the ones the database uses.

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.