1. Scott Roberts
  2. Valentina Database ADK
  3. Donnerstag, Juli 05 2018, 03:11 PM
  4.  Abonnieren via E-Mail
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.
Anhänge
Kommentar
There are no comments made yet.
Scott Roberts Akzeptierte Antwort
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.
Kommentar
There are no comments made yet.
Lynn Fredricks Akzeptierte Antwort
Were you able to sort this out, Scott?
Kommentar
There are no comments made yet.
Scott Roberts Akzeptierte Antwort
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.
Kommentar
There are no comments made yet.
  • 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