PxPlus User Forum

Main Board => Knowledge Base / Training => FAQs => Topic started by: PxPlus on May 30, 2018, 04:28:10 PM

Title: Why does SELECT with opened file seem to miss records
Post by: PxPlus on May 30, 2018, 04:28:10 PM
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.