1. Scott Roberts
  2. Valentina Database ADK
  3. 木, 7月 05 2018, 03:11 PM
  4.  メールで購読
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