HISTORY

The syntax gets list of tables released to the history with all the living assignments.

Practical example

Command:

HISTORY

Output:

HISTORY
{
table01
table01.table10
table01.table10.table20
}




HISTORY [id]

The syntax lists all the tables in history with living assignments and their IDs. More tables may be visible than using the HISTORY keyword, because under one similar table name can be multiple tables.

Practical example

Command:

HISTORY [ID]

Output:

HISTORY
{
table01=CC81A53DC4274A458799848E0D637517
table01.table10=39D4FC2C1B46402D97D5706815043C53
table01.table10.table20=9E3D16EA86B14550A7395D698A7C707D
}




HISTORY [nil]

The syntax clears the history permanently.

Practical example

Command:

HISTORY [nil]

Output:

HISTORY :: CLEAR :: DONE




HISTORY tablename

The syntax gets list of tables assigned to a table which had been released to the history.

  • tablename: The name of the table with full path.

Practical example

Command:

HISTORY table01

Output:

HISTORY :: IVF
{
table01.table10
table01.table10.table20
}




HISTORY tablename[id]

The syntax lists a table's ID in history with living assignments's IDs. More tables may be visible than using the HISTORY tablename keyword, because under one similar table name can be multiple tables.

Practical example

Command:

HISTORY table01[ID]

Output:

HISTORY
{
CC81A53DC4274A458799848E0D637517
}




HISTORY tablename[restore]

The syntax restores a table from the history.

  • tablename: The name of the table with full path.

Practical example

Command:

HISTORY table01[restore]

Output:

HISTORY :: TABLE RESTORED :: TABLE01[RESTORE]




HISTORY tablename[startcolumn, startrow, endcolumn, endrow]

The syntax gets table's data from history.

  • tablename: The name of the table with full path.
  • startcolumn: The first column of the data selection.
  • startrow: The first row of the data selection.
  • endcolum: The last column of the data selection.
  • endrow: The last column of the data selection.

Practical example

Command:

HISTORY table01[1,1,3,2]

Output:

HISTORY :: table01
record,record,record
record,record,record
record,record,record




HISTORY tablename[nil]

The syntax removes a table from the history.

  • tablename: The name of the table with full path.

Practical example

Command:

HISTORY table01[nil]

Output:

HISTORY :: TABLE DELETED :: TABLE01[NIL]