FOR statements
- Last Updated: March 30, 2020
- 1 minute read
- OpenEdge
- Version 12.2
- Documentation
FOR FIRST and FOR LAST statements that cause the DataServer to sort data before returning it to
the client behave differently when returning data from a MS SQL Server data source than when
returning data from an OpenEdge database. The data source might not sort data like the
OpenEdge database does, so the order in which records return might differ. In addition, the
server-side result set is limited to a single record to improve performance.