GET tablename[]

The syntax above gets all data from a table.

  • tablename: The name of the table with full path to get data from.

Theoretical example

Command:

GET table01[]

Output:


Practical example

Command:

GET table01[]

Output:

GET::TABLE01[]
record,record,record,record
record,record,record,record
record,record,record,record
record,record,record,record

You can see that the output returns the sended command too. To avoid that use minus switch at the end of the syntax:

Command:

GET table01[]-

Output:

record,record,record,record
record,record,record,record
record,record,record,record
record,record,record,record



GET tablename[column, row]

The syntax above gets a cell's data from a table.

  • tablename: The name of the table with full path to get data from.
  • column: The column of the data cell.
  • row: The row of the data cell.

Theoretical example

Command:

GET table01[2,3]

Output:


Practical example

Command:

GET table01[2,3]

Output:

GET::TABLE01[2,3]
record



GET tablename[startcolumn, startrow, endcolumn, endrow]

The syntax above gets selected data from a table.

  • tablename: The name of the table with full path to get data from.
  • 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.

Theoretical example

Command:

GET table01[1,1,3,2]

Output:


Practical example

Command:

GET table01[1,1,3,2]

Output:

GET table01[1,1,3,2]
record,record,record
record,record,record
record,record,record



GET tablename[-1, -1]

The syntax above gets the last record from a table.

  • tablename: The name of the table with full path to get data from.
  • -1 (first parameter): The last column of a table.
  • -1 (second parameter): The last row of a table.

Theoretical example

Command:

GET table01[-1,-1]

Output:


Practical example

Command:

GET table01[-1,-1]

Output:

GET::TABLE01[-1,-1]
record



GET tablename[-1]

The syntax above gets all records from a table similarly to the first expression (GET tablename[]).

  • tablename: The name of the table with full path to get data from.
  • -1: Indicates that you want all data.

Theoretical example

Command:

GET table01[-1]

Output:


Practical example

Command:

GET table01[-1]

Output:

GET::TABLE01[-1]
record,record,record,record
record,record,record,record
record,record,record,record
record,record,record,record



GET tablename[0, 0, -1, -1]

The syntax above gets all records from a table similarly to the previous expression (GET tablename[-1]).

  • tablename: The name of the table with full path to get data from.
  • 0 (first parameter): The first column of a table.
  • 0 (second parameter): The first row of a table.
  • -1 (third parameter): The last column of a table.
  • -1 (fourth parameter): The last row of a table.

Theoretical example

Command:

GET table01[0,0,-1,-1]

Output:


Practical example

Command:

GET table01[0,0,-1,-1]

Output:

GET::TABLE01[0,0,-1,-1]
record,record,record,record
record,record,record,record
record,record,record,record
record,record,record,record