PxPlus User Forum

Twitter Twitter Twitter

Author Topic: Why does SELECT with opened file seem to miss records  (Read 1963 times)

PxPlus

  • Administrator
  • Diamond Member
  • *****
  • Posts: 1091
    • View Profile
Why does SELECT with opened file seem to miss records
« 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.
« Last Edit: June 15, 2018, 06:22:49 PM by PxPlus »