Operations on the rows and cells
Deleting a row
The deletion of a row must be explicitly requested by 表格删除
. The following syntax is used:
表格删除(<Name of Table Control> [, <Subscript>])
If the subscript is specified, 表格删除
deletes the row corresponding to the subscript. Otherwise, the current row is deleted. For example:
The deletion of a Table control row also deletes all the values of the columns for this row.
Selecting the row
The selection of a row is performed by 表格选择行
The following syntax is used:
表格选择行(<Name of Table Control>[, <Subscript>])
Retrieving the content of a row or the content of a cell
The content of a memory table can be retrieved:
- for the entire row.
- cell by cell.
Value of a cell in the current row
To retrieve the value of a column (or cell) for the current row, the syntax is the same as for a simple edit control.
// COL_QTY is a column of the Table control
Value of a cell in a specific row
To retrieve the value of a column not found on the current row, the subscript of the row must be specified.
<Value> = <Column_Name>[<Subscript>]
// Add the total price before tax (PBT) for all the order lines
Content of the current row
To retrieve the content of the current row, use the following syntax:
Content of a specific row
To retrieve the content of the row whose subscript is <Subscript>, use the following syntax:
<Value> = <Table_Name>[<Subscript>]
: The subscript of the current row is returned by 表格选定行
. For example:
// Retrieve row #10 in the TABLE_CUSTOMER control
// Name of selected customer
// Retrieve the current row in the TABLE_CUSTOMER control