1. Scott Roberts
  2. Valentina Database ADK
  3. Четверг, Июль 05 2018, 03:11 PM
  4.  Подписаться через email
I am attempting to sort query results based on a date/time field; however, the results do not sort as expected.

I have attached an SQL file with a dump of the table along with a screenshot with my query and its results (from the SQL Editor tool).

There is some type of sorting happening (the records are not in the same order as they would be if I omitted the ORDER BY clause), but they are not in the order of the date/time field.
Вложения
Комментарий
There are no comments made yet.
Scott Roberts Ответ принят
I am not able to reproduce this from scratch so I am going to assume that my database was corrupted somehow during my testing and debugging.
Комментарий
There are no comments made yet.
Lynn Fredricks Ответ принят
Were you able to sort this out, Scott?
Комментарий
There are no comments made yet.
Scott Roberts Ответ принят
It hasn't happened again. I deleted the database and had my application create another one. I was trying to put together something to post on Mantis when I realized that I could not recreate the problem from scratch. Everything seems to be OK now.
Комментарий
There are no comments made yet.
  • Страница :
  • 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