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

Hi,

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.

Marcos

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

Hi Marcos;

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

Comment
Hi Chris,

I'm using DW.

Regards.

Marcos
  1. Marcos Bolonha
  2. Wednesday, 4 December 2019 16:43 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. Chris Pollach @Appeon
  2. Wednesday, 4 December 2019 17:03 PM UTC
Chris,

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?



Thanks.



Marcos
  1. Marcos Bolonha
  2. Wednesday, 4 December 2019 17:42 PM UTC
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.