MySQL Forums
Forum List  »  Microsoft Access

Re: Beginning and end of table
Posted by: Robert Tulloch
Date: March 28, 2018 05:13PM


Have a form with fields I populated from MySQL using queries and JSON to return data and populate the form fields.

Form includes a navigator control to scroll the records one by one. I have three different "ORDERS" for data implemented through ALTER TABLE mytable ORDER BY myfield ASC etc. When scrolling to last record I would like an indication if that record is the last (or first) in the ordered table so I can disable the first and previous or next and last buttons on the control indicating the begging or end of the "table".

This is all working except for addressing the issue as described above. I can accomplish this with some background selects but I figured that there must exist some status flags indicating beginning and end of table records that I can access with a call.

Options: ReplyQuote

Written By
March 28, 2018 12:24PM
March 28, 2018 01:07PM
Re: Beginning and end of table
March 28, 2018 05:13PM
March 28, 2018 08:35PM
March 29, 2018 06:05AM
March 29, 2018 06:34AM
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.