Skip to main content
Version: 20 R7 BETA

Is record loaded

Is record loaded {( aTable )} : Boolean

ParameterTypeDescription
aTableTable→Table of the record to examine or Default table if this parameter is omitted
Function resultBoolean←True if the record is loaded Otherwise False

Description​

The Is record loaded command returns True if aTable’s current record is loaded in the current process.

4D Server: In principle, when tables are linked by automatic relations, the current records of related tables are loaded automatically (see About Relations). However, for optimization reasons, 4D Server only loads these records when necessary, for example when reading or assigning a field of the related record. As a result, in this context the Is record loaded command will return False in remote mode (it returns True in local mode).

Example​

Instead of using the “Next record” or “Previous record” automatic actions, you can write object methods for these buttons to improve their operation. The “Next” button will display the beginning of the selection if the user is at the end of the selection and the “Previous” button will show the end of the selection when the user is at the beginning of the selection.

  // Object method of the “Previous” button (without an automatic action)
 If(FORM Event=On Clicked)
    PREVIOUS RECORD([Group])
    If(Not(Is record loaded([Group])))
       GOTO SELECTED RECORD([Group];Records in selection([Group]))
  //Go to the last record in the selection
    End if
 End if
 
  // Object method of the “Next” button (without an automatic action)
 If(FORM Event=On Clicked)
    NEXT RECORD([Group])
    If(Not(Is record loaded([Group])))
       GOTO SELECTED RECORD([Groups];1)
  //Go to the first record in the selection
    End if
 End if