Hi expert,
The value returned by the :SYSTEM.BLOCK_STATUS are: NEW, INSERT and CHANGED.
- If a new record is added to block, the block status is INSERT.
- If a new record is added and one of existing records is modified, the block status is CHANGED.
- If a record is deleted from the block, the block status is CHANGED.
- If the block is empty, the block status is NEW.
If based on the block status, is there any easy way to know what exact activity on the block
without looping through the data block? I want to know what exact activity has been happened on
the block, whether the *Change* is a deletion, or a inserton, or an update.
Thanks
The value returned by the :SYSTEM.BLOCK_STATUS are: NEW, INSERT and CHANGED.
- If a new record is added to block, the block status is INSERT.
- If a new record is added and one of existing records is modified, the block status is CHANGED.
- If a record is deleted from the block, the block status is CHANGED.
- If the block is empty, the block status is NEW.
If based on the block status, is there any easy way to know what exact activity on the block
without looping through the data block? I want to know what exact activity has been happened on
the block, whether the *Change* is a deletion, or a inserton, or an update.
Thanks