1. Marcos Bolonha
  2. PowerServer Mobile (Obsolete)
  3. Wednesday, 4 December 2019 13:50 PM UTC


I have a new problem with PowerServer Mobile x SQLite3 numeric datatype columns on local database. The table has numeric(10,4) datatype columns. When I type the values they are saved corretcly (10,4), but when I retrieve the same data from table the PB recognize it as an integer. Any idea how to solve this issue?

PB Universal 2019 biuld 2082

PowerServer 2019 build 2151

Device's OS: Android 9

SQLite3 version on device: 3.26.0

Thanks in advanced.


Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 4 December 2019 16:22 PM UTC
  2. PowerServer Mobile (Obsolete)
  3. # 1

Hi Marcos;

   Are using a DW object to access this table & column or in-line SQL?
Regards ... Chris

  1. Marcos Bolonha
  2. Wednesday, 4 December 2019 16:43 PM UTC
Hi Chris,

I'm using DW.


  1. Helpful
  1. Chris Pollach @Appeon
  2. Wednesday, 4 December 2019 17:03 PM UTC
1) Are you building the DWO then by connecting the PB IDE to an identical SL3 DB?

2) Does the DWO work properly from the PB IDE on the development SL3 DB?

3) Is the Android device's SL3 DB schema exactly the same?
  1. Helpful
  1. Marcos Bolonha
  2. Wednesday, 4 December 2019 17:42 PM UTC

1) Yes and also I'm forcing the DB update each time the App is open on device (of_applydbupdate()).

2) Yes on PB IDE the DWO works properly.

3) Well, sorry I don't how to check the schema. Normaly we use MS SQL Server on our client-server projects and it's the first time I'm using SQLite3 and mobile app. Any advice how to check it?


  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.