Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved PB x SQLite3 datatype columns issue

  1. Issue
0
Votes
Undo
  1. Marcos Bolonha
    Marcos Bolonha
  2. PowerServer Mobile (Obsolete)
  3. Friday, 22 November 2019 12:34 PM UTC

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

  1. DataType
  2. PowerServer Mobile
  3. SQLite
Mobile error deploying application
Mobile offline
Responses (2)
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Friday, 22 November 2019 13:48 PM UTC
  2. PowerServer Mobile (Obsolete)
  3. # 1

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.
Marcos Bolonha
Marcos Bolonha Accepted Answer Pending Moderation
  1. Monday, 25 November 2019 13:24 PM UTC
  2. PowerServer Mobile (Obsolete)
  3. # 2

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
Roland Smith
  1. Roland Smith
  2. Monday, 25 November 2019 14:17 PM UTC
Great! Which driver are you using?
  1. Helpful
Marcos Bolonha
  1. Marcos Bolonha
  2. Monday, 25 November 2019 14:30 PM UTC
SQLite3 ODBC Driver - version 0.9996.00.00 by Cristian Werner Software and Consulting.



Marcos
  1. Helpful
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.