Toggle Submenu
  1. Forums
  2. Recent
  3. Категории
  4. Теги
  5. Пользователи
Добавить ответ Показать ответы (4)

Решено Help - SQL result as a scientific notation

  1. Camila Vernalha
    Camila Vernalha
  2. as SQLite DB Server
  3. Среда, Апрель 28 2021, 02:13 PM
  4.  Подписаться через 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
Вложения
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
Комментарий
There are no comments made yet.
Ответы (4)
Sergey Pashkov
Sergey Pashkov Ответ принят
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.
Комментарий
There are no comments made yet.
  1. больше, чем месяц назад
  2. as SQLite DB Server
  3. Постоянная ссылка на этот ответ
Camila Vernalha
Camila Vernalha Ответ принят
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
Вложения
Captura de Tela 2021-04-28 às 13.03.36.png Captura de Tela 2021-04-28 às 13.03.36.png
Комментарий
There are no comments made yet.
  1. больше, чем месяц назад
  2. as SQLite DB Server
  3. Постоянная ссылка на этот ответ
Sergey Pashkov
Sergey Pashkov Ответ принят
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.
Комментарий
There are no comments made yet.
  1. больше, чем месяц назад
  2. as SQLite DB Server
  3. Постоянная ссылка на этот ответ
Camila Vernalha
Camila Vernalha Ответ принят
Sergey, you are right.

I downloaded the latest version and the problem is solved.

Tks a lot.
Комментарий
There are no comments made yet.
  1. больше, чем месяц назад
  2. as SQLite DB Server
  3. Постоянная ссылка на этот ответ
  • Страница :
  • 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