Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Limitation of :SYSTEM.BLOCK_STATUS

Status
Not open for further replies.

wesbooks

Programmer
Sep 8, 2002
22
CA
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top