Equinox Online Help - Language Reference - A to Z
NextRecord |
|
---|---|
Applies to | |
Syntax | NextRecord [LockExpression] |
Action | [Statement] Selects the next record in a table. |
Scope | Only usable in forms or subtables. |
Notes | This statement selects the next record in the current index. LockExpression allows you to control locking on the new record and may take one of the following values:
If LockExpression is omitted, it defaults to zero. Note that you only need to lock a record if you intend to edit its fields. If you only want to read values, it is not necessary to lock it. Also note that an applied lock is automatically released when a new record is selected. However, if required, you may manually release the lock before changing records, using the Unlock statement. After the statement is executed, the SysError system workarea is set to one of the following values:
|
Category | Record navigation |
See Also | GroupFirstRecord, GroupLastRecord, GroupNextRecord, GroupPreviousRecord, GroupSkipRecord, LastRecord, NextRecord |
Example | This method (attached to a button on a form) determines if the current record is being edited or inserted. If not, the next record is selected. If SysMode = NoMode, ViewMode Then NextRecord The next example steps through the current customer's orders and adds up the total value. number total |