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

Resolved PB x SQLite3: numeric(10,4) datatype columns are assign as an integer on retrieve

  1. Issue
0
Votes
Undo
  1. Marcos Bolonha
    Marcos Bolonha
  2. PowerServer Mobile (Obsolete)
  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

Mobile offline
Actualizing the mobile app with the Appeon Workspa...
Responses (1)
Chris Pollach @Appeon
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

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

I'm using DW.

Regards.

Marcos
  1. Helpful
Chris Pollach @Appeon
  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
Marcos Bolonha
  1. Marcos Bolonha
  2. Wednesday, 4 December 2019 17:42 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. 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.