The examples will be based on a copy of the demo database
Sports 2000 provided with the setup of Progress.
When working with queries in Progress you need to:
DEFINE the query and set what buffers (tables) and fields it works against.
OPEN the query with a specific
WHERE-clause that defines how to retrieve the records. Possibly also sorting (
GET the actual data - that can be the
PREV (for previous) or
LAST matching record.