Re: Beginning and end of table

[Robert Tulloch]

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.