Toggle Submenu
  1. Forums
  2. Recent
  3. Kategorien
  4. Tags
  5. Benutzer
Antwort hinzufügen Antworten ansehen (4)

Gelöst Help - SQL result as a scientific notation

  1. Camila Vernalha
    Camila Vernalha
  2. as SQLite DB Server
  3. Mittwoch, April 28 2021, 02:13 PM
  4.  Abonnieren via E-Mail
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
Anhänge
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
Kommentar
There are no comments made yet.
Antworten (4)
Camila Vernalha
Camila Vernalha Akzeptierte Antwort
Sergey, you are right.

I downloaded the latest version and the problem is solved.

Tks a lot.
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. as SQLite DB Server
  3. Permalink zu dieser Antwort
Sergey Pashkov
Sergey Pashkov Akzeptierte Antwort
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.
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. as SQLite DB Server
  3. Permalink zu dieser Antwort
Camila Vernalha
Camila Vernalha Akzeptierte Antwort
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
Anhänge
Captura de Tela 2021-04-28 às 13.03.36.png Captura de Tela 2021-04-28 às 13.03.36.png
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. as SQLite DB Server
  3. Permalink zu dieser Antwort
Sergey Pashkov
Sergey Pashkov Akzeptierte Antwort
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.
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. as SQLite DB Server
  3. Permalink zu dieser Antwort
  • Seite :
  • 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