4D v14.3

UNLOAD RECORD

Home

 
4D v14.3
UNLOAD RECORD

UNLOAD RECORD 


 

UNLOAD RECORD {( aTable )} 
Parameter Type   Description
aTable  Table in Table for which to unload record, or Default table, if omitted

UNLOAD RECORD unloads the current record of table.

If the record is unlocked for the local user (locked for the other users), UNLOAD RECORD unlocks the record for the other users.

Although UNLOAD RECORD unloads it from memory, the record remains the current record. When another record is made the current record, the previous current record is automatically unloaded and therefore unlocked for other users. Always execute this command when you have finished modifying a record and want to make it available to other users, while retaining the record as your current record.

If a record has a large amount of data, picture fields, or external documents (such as 4D Write or 4D Draw documents), you may not want to keep the current record in memory unless you need to modify it. In this case, use the UNLOAD RECORD command to keep the current record without having it in memory. You free the memory occupied by the record, but you do not have access to its field values. If you later need access to the values of the record, use the LOAD RECORD command.

Note: When it is used in a transaction, the UNLOAD RECORD command unloads the current record only for the process that manages the transaction. For other processes, the record stays locked as long as the transaction has not been validated (or cancelled).

 
PROPERTIES 

Product: 4D
Theme: Record Locking
Number: 212

 
HISTORY 

Created: < 4D v6

 
SEE ALSO 

LOAD RECORD
Record Locking

 
ARTICLE USAGE

4D Language Reference ( 4D v12.4)
4D Language Reference ( 4D v11 SQL Release 6)
4D Language Reference ( 4D v14 R3)
4D Language Reference ( 4D v14 R2)
4D Language Reference ( 4D v13.5)
4D Language Reference ( 4D v14.3)
4D Language Reference ( 4D v14 R4)