Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: wrong data sorting

wrong data sorting 5 months 1 week ago #18843

  • infoeos
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 5
  • Thank you received: 0
Hi, I have another problem with data sorting as you can see in the attached image.
The database is Access and a table with a regular ID.
This happen with all kind of columns (date, text, etc..) but it happen only when I don't scroll down all the rows. If before sorting, I scroll down all the data, the sorting works properly.
Is there a way to fix this (without scrolling down)?
Attachments:

Please Log in or Create an account to join the conversation.

wrong data sorting 5 months 1 week ago #18844

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7517
  • Karma: 33
  • Thank you received: 409
This is by design.
Data is sorted in memory when you click on field title.
Not all data is fetched from the the database when sql is executed because if you have 100 millions of records it will take a lot of time.

My suggestion is to scroll to the end than click on field title. or use order by clause
Mike

Please Log in or Create an account to join the conversation.

  • Page:
  • 1

We have 167 guests and 3 members online