Difference between revisions of "SET TIMELINE"

From Lianjapedia
Jump to: navigation, search
m (1 revision)
(See Also)
(14 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
==Purpose==
 
==Purpose==
 
Enable database timelines for row versioning
 
Enable database timelines for row versioning
 
  
 
==Syntax==
 
==Syntax==
 
SET TIMELINE ON | OFF
 
SET TIMELINE ON | OFF
 
  
 
==See Also==
 
==See Also==
[[CLEAR TIMELINE]], [[LIST TIMELINE]], [[ROLLBACK TIMELINE]], [[SET TIMESTAMP]], [[SYSTIMELINE]], [[UNWATCH()]], [[WATCH()]], [[WATCHCHANGED()]], [[WATCHING()]], [[WATCHRESET()]]
+
[[ALTER DATABASE]], [[CLEAR TIMELINE]], [[:Category:Database Timelines|Database Timelines Commands and Functions]], [[Database Timelines (Video)]], [[LIST TIMELINE]], [[MetaData Editor]], [[ROLLBACK TIMELINE]], [[SET SYSTIMELINE]], [[SET TIMESTAMP]], [[SYSTIMELINE|Systimeline System Table]], [[TIMELINE()]], [[Timeline Section Attributes]], [[Understanding database timelines in Lianja|Understanding Database Timelines]]
 
+
  
 
==Description==
 
==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.  To enable database timelines simply issue the SET TIMELINE ON command in your Recital configuration file.  SET TIMELINE is OFF by default.
+
Database timelines provide row versioning for Lianja 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.
  
 +
Timelines can also be enabled for a specific database in its metadata.  In the [[MetaData_Editor#Database_MetaData|MetaData Editor]] specify the Attribute as ''timeline'' and the Value as ''on''.  Alternatively, use the [[ALTER DATABASE]] command as shown below.
  
 
==Example==
 
==Example==
<pre>
+
<code lang="recital">
**********************
+
* File    : config.db
+
*
+
* ...
+
 
set timeline on
 
set timeline on
*...
 
*
 
</pre>
 
  
 +
// Or set in the database metadata to always apply to the specified database
 +
alter database southwind metadata "timeline=on"
 +
</code>
  
==Products==
 
Recital, Recital Server
 
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Set Commands|TIMELINE]]
 
[[Category:Set Commands|TIMELINE]]
 +
[[Category:Databases]]
 
[[Category:Database Timelines]]
 
[[Category:Database Timelines]]
 +
[[Category:Lianja VFP Extensions]]
 +
[[Category:VFP Command Extensions]]

Revision as of 07:20, 26 March 2020

Purpose

Enable database timelines for row versioning

Syntax

SET TIMELINE ON | OFF

See Also

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

Description

Database timelines provide row versioning for Lianja 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.

Timelines can also be enabled for a specific database in its metadata. In the MetaData Editor specify the Attribute as timeline and the Value as on. Alternatively, use the ALTER DATABASE command as shown below.

Example

set timeline on
 
// Or set in the database metadata to always apply to the specified database
alter database southwind metadata "timeline=on"