Try OpenEdge Now
skip to main content
Programming Interfaces
Data Management : Database Access : Fetching records : FIND repositioning
FIND repositioning
After executing FOR EACH statements or FIND statements, the AVM might reposition subsequent FIND statements to the last record fetched (except for FIND statements occurring in PRESELECT blocks). For repositioning to occur, the same record buffer must be used. Also, repositioning after FOR EACH statements can differ between Progress Version 8.0B and Versions 8.0A and earlier, depending on the options you use.
Note: Repositioning does not occur for a subsequent FIND if the FIND specifies a unique key (that is, the FIND does not use the NEXT or PREV options).
* Repositioning after FIND fetches