MySQL Forums
Forum List  »  Microsoft Access

Re: Beginning and end of table
Posted by: Robert Tulloch
Date: March 29, 2018 06:05AM

Thanks for response.

You say: To order row display, use queries with Order By clauses, optimise them correctly for performance, use Where or Limit clauses to paginate, and write code to keep track of which row the user is in her browsing.

I do all of that in addition to ordering the table with alter as backup. When I
select the next row based say on lastname and include order by, I assumed the oder by applied to the returned dataset. in my cast this is one so I don't see how using the order by clause is relevant in that context.

Options: ReplyQuote


Subject
Views
Written By
Posted
1172
March 28, 2018 12:24PM
609
March 28, 2018 01:07PM
742
March 28, 2018 05:13PM
744
March 28, 2018 08:35PM
Re: Beginning and end of table
748
March 29, 2018 06:05AM
634
March 29, 2018 06:34AM
728
March 29, 2018 07:00AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.