Why does SELECT with opened file seem to miss records

Started by PxPlus, May 30, 2018, 04:28:10 PM

Previous topic - Next topic

PxPlus

When using a SELECT with a file that you have manually opened in your application it is important to remember that the SELECT will start from the current position in the file UNLESS you include a BEGIN or END clause on the SELECT directive.

Including a BEGIN forces the system to reposition to the specified key prior the start of the SELECT loop.

To assure processing the complete file use BEGIN "". An End is not needed.