1. Scott Roberts
  2. Valentina Database ADK
  3. Thursday, July 05 2018, 03:11 PM
  4.  Subscribe via 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.
Attachments (1)
Comment
There are no comments made yet.
Scott Roberts Accepted Answer
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.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 1
Lynn Fredricks Accepted Answer
Were you able to sort this out, Scott?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 2
Scott Roberts Accepted Answer
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.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 3
  • 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