Sets the position on the next data file record according to a browse item.
The record is not read.The number of the current record is modified only when it is returned by
<Source>.RecNum. For the functions that handle the current record number (
<Source>.Delete,
<Source>.Read,
<Source>.Modify, etc.), the value of this number is not updated: you must use
<Source>.RecNum(). For example: not to do:
but
Customer.Delete(Customer.RecNum())
Values in the browse item are read in ascending order (see Remarks for more details).
Caution: The record loaded in memory is not modified. The HFSQL variables (Customer.Name for example, which means the Name item of Customer file) are not updated.
In most cases,
<Source>.Next sets the position in the data file to loop through the records that match a condition.
<Source>.Next is used to position on the next record corresponding to the condition.
Several cases may occur after the call to <Source>.Next:
- a record corresponding to the condition was found: <Source>.Found returns True
- the data file is empty or there is no record corresponding to the condition: <Source>.Out returns True
Remarks:
Values in the browse item are read in ascending order (for more details, see the remarks).
Caution: The record loaded in memory is not modified. The HFSQL variables (for example Customer.Name, i.e. the Name item of the Customer file) are not updated.
Generally, <Source>.Next sets the position in the data file during a loop operation.
Several cases may occur after the call to <Source>.Next:
- the data file is empty or no record corresponds to the filter (defined by <Source>.Filter): <Source>.Out returns True
- the function tries to lock a record that is already locked in read-only: HErrorLock returns True and <Source>.Out returns True.
Access by JDBC: Locks cannot be managed in databases accessed by JDBC.