Difference between revisions of "SET SYSTIMELINE"

From Lianjapedia
Jump to: navigation, search
(Created page with "==Purpose== Enable global database timeline override ==Syntax== SET SYSTIMELINE ON | OFF ==See Also== CLEAR TIMELINE, LIST TIMELINE, ROLLBACK TIMELINE, SET()...")
 
(Description)
 
(6 intermediate revisions by 2 users not shown)
Line 6: Line 6:
  
 
==See Also==
 
==See Also==
[[CLEAR TIMELINE]], [[LIST TIMELINE]], [[ROLLBACK TIMELINE]], [[SET()]], [[SET TIMELINE]], [[SET TIMESTAMP]], [[SYSTIMELINE]], [[TIMELINE()]]
+
[[ALTER DATABASE]], [[CLEAR TIMELINE]], [[:Category:Database Timelines|Database Timelines Commands and Functions]], [[Database Timelines (Video)]], [[LIST TIMELINE]], [[MetaData Editor]], [[ROLLBACK TIMELINE]], [[SET TIMELINE]], [[SET TIMESTAMP]], [[SYSTIMELINE|Systimeline System Table]], [[TIMELINE()]], [[Timeline Section Attributes]], [[Understanding database timelines in Lianja|Understanding Database Timelines]]
  
 
==Description==
 
==Description==
Line 18: Line 18:
  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
[[Category:Set Commands|TIMELINE]]
+
[[Category:Set Commands|SYSTIMELINE]]
 
[[Category:Databases]]
 
[[Category:Databases]]
 
[[Category:Database Timelines]]
 
[[Category:Database Timelines]]
 +
[[Category:Lianja VFP Extensions]]
 +
[[Category:VFP Command Extensions]]

Latest revision as of 07:27, 28 March 2020

Purpose

Enable global database timeline override

Syntax

SET SYSTIMELINE ON | OFF

See Also

ALTER DATABASE, CLEAR TIMELINE, Database Timelines Commands and Functions, Database Timelines (Video), LIST TIMELINE, MetaData Editor, ROLLBACK TIMELINE, SET TIMELINE, SET TIMESTAMP, Systimeline System Table, TIMELINE(), Timeline Section Attributes, Understanding Database Timelines

Description

Database timelines provide row versioning for Lianja database tables. 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. The global setting SET SYSTIMELINE must be ON to use the SET TIMELINE command or Timeline Attributes to enable timelines for an individual table or application. SET SYSTIMELINE is ON by default.

Example

set systimeline on
set timeline on