Difference between revisions of "SET TIMELINE"

From Lianjapedia
Jump to: navigation, search
Line 6: Line 6:
  
 
==See Also==
 
==See Also==
[[CLEAR TIMELINE]], [[LIST TIMELINE]], [[ROLLBACK TIMELINE]], [[SET TIMESTAMP]], [[SYSTIMELINE]], [[TIMELINE()]]
+
[[CLEAR TIMELINE]], [[LIST TIMELINE]], [[ROLLBACK TIMELINE]], [[SET SYSTIMELINE]], [[SET TIMESTAMP]], [[SYSTIMELINE]], [[TIMELINE()]]
  
 
==Description==
 
==Description==

Revision as of 11:25, 7 December 2012

Purpose

Enable database timelines for row versioning

Syntax

SET TIMELINE ON | OFF

See Also

CLEAR TIMELINE, LIST TIMELINE, ROLLBACK TIMELINE, SET SYSTIMELINE, SET TIMESTAMP, SYSTIMELINE, TIMELINE()

Description

Database timelines provide row versioning for Recital database applications. Whenever a change is made to a table that is timeline enabled, delta changes are automatically recorded for each transaction. Changes made to any tables that are timeline enabled can be undone much like you would undo changes to program code that you edit in a text editor. SET TIMELINE is OFF by default.


Example

set timeline on