Main Board > FAQs

Why does SELECT with opened file seem to miss records


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.


[0] Message Index

Go to full version