Try OpenEdge Now
skip to main content
DataServer for Microsoft SQL Server
Initial Programming Considerations : ABL issues : FOR statements

FOR statements

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.