1. Camila Vernalha
  2. as SQLite DB Server
  3. Wednesday, April 28 2021, 02:13 PM
  4.  Subscribe via email
Hello,

I am using Valentina Studio to consult a SQL DB.

When using a select function I have the result on scientific notation, as the image attached.


How do I change this settings to see the number as it was saved on the DB, as a numeric formatt?

Tks
Attachments (1)
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hello Camila,

So it is an SQLite database hosted on Valentina Server, right?

Could you please specify the type of the Valor field? It is shown in the Property Inspector of Schema Editor.
Comment
There are no comments made yet.
Camila Vernalha Accepted Answer
Hello Camila,

So it is an SQLite database hosted on Valentina Server, right?

Could you please specify the type of the Valor field? It is shown in the Property Inspector of Schema Editor.


Hi Sergeiy, thanks for your help.

I am sending a image attached, can you check if is this the information you mean?

Tks
Attachments (1)
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Looks like it is not the latest version (11.2.5).
Value processing has changed in this version and I can't reproduce this behaviour.
Comment
There are no comments made yet.
Camila Vernalha Accepted Answer
Sergey, you are right.

I downloaded the latest version and the problem is solved.

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


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

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories