MySQL Forums
Forum List  »  Microsoft Access

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

Hi:

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


Subject
Views
Written By
Posted
167
March 28, 2018 12:24PM
94
March 28, 2018 01:07PM
Re: Beginning and end of table
116
March 28, 2018 05:13PM
114
March 28, 2018 08:35PM
112
March 29, 2018 06:05AM
102
March 29, 2018 06:34AM
125
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.