This statement selects the record before the current record, in the current index.

LockExpression allows you to control locking on the new record and may take one of the following values:

• 0 The previous record is selected and no lock is applied.
• 1 The previous record is selected and locked (if not already locked by another user).
• 2 Equinox selects the nearest previous record that is not already locked by another user and locks it.

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:

• 0 The statement was executed successfully.
• 1 An error occurred.
• 2 This value is returned if LockExpression was set to 1, but the previous record was already locked, ie the lock failed.

This example tests to see if the user is editing or inserting a record. If not, then the previous record is selected.

If SysMode = NoMode, ViewMode Then PreviousRecord