Difference between revisions of "SET TIMELINE"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision) |
Yvonne.milne (Talk | contribs) |
||
| 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]], [[ | + | [[CLEAR TIMELINE]], [[LIST TIMELINE]], [[ROLLBACK TIMELINE]], [[SET TIMESTAMP]], [[SYSTIMELINE]], [[TIMELINE()]] |
| − | + | ||
==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 | + | 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== | ==Example== | ||
| − | < | + | <code lang="recital"> |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
set timeline on | set timeline on | ||
| − | + | </code> | |
| − | + | ||
| − | </ | + | |
| − | + | ||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Set Commands|TIMELINE]] | [[Category:Set Commands|TIMELINE]] | ||
| − | [[Category: | + | [[Category:Databases]] |
Revision as of 06:16, 7 December 2012
Contents
Purpose
Enable database timelines for row versioning
Syntax
SET TIMELINE ON | OFF
See Also
CLEAR TIMELINE, LIST TIMELINE, ROLLBACK TIMELINE, 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
