Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
Add a reply View Replies (4)

Resolved Help - SQL result as a scientific notation

  1. Camila Vernalha
    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)
Captura de Tela 2021-04-28 às 11.10.21.png Captura de Tela 2021-04-28 às 11.10.21.png
  1. SOLVED!
  2. sql editor
Comment
There are no comments made yet.
Responses (4)
Camila Vernalha
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.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 1
Sergey Pashkov
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.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 2
Camila Vernalha
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)
Captura de Tela 2021-04-28 às 13.03.36.png Captura de Tela 2021-04-28 às 13.03.36.png
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 3
Sergey Pashkov
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.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 4
  • 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