<Table>.ModifyLine (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / WLanguage functions / Controls, pages and windows / Table functions

Use conditions
Characteristics of the row elements
Table field/Hierarchical file table: Changes to the linked data file
Changes in a Table or TreeView Table control based on a data file

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Table>.ModifyLine (Function)

In french: <Table>.ModifieLigne

Modifies a row in:

a Table control,
a TreeView Table control.

Example

// Modification des éléments "Paul" et "Dubois" 
// de la cinquième ligne du champ Table "TABLE_TableClient"
TABLE_TableClient.ModifieLigne(5, "Paul", "Dubois")

Syntax

<Table control>.ModifyRow(<Index> [, <Element column 1> [... [, <Element column N>]]])

<Table control>: Control name

Name of the control to be used. This control can correspond to:
a Table control.
a TreeView Table control.

<Index>: Integer

Index of the row to be modified. The index of the first row is set to 1.
Index equal to -1 The current row is modified. No effect if no row is selected.
Index greater than the number of control rows A WLanguage error occurs.

<Element column 1>: Optional character string

First element of the modified row. The value of this element replaces the existing value. Each element corresponds to a column. Each type of modified element must be compatible with the type of relevant column.
If none of the <Element column X> parameters are specified, <Table>.ModifyLine has no effect.

<Element column N>: Optional character string

Nth element of the modified row. The value of this element replaces the existing value. Each element corresponds to a column. Each type of modified element must be compatible with the type of relevant column.
If none of the <Element column X> parameters are specified, <Table>.ModifyLine has no effect.

Remarks

Use conditions

<Table>.ModifyLine can be used on:

Table or TreeView Table controls based on a data file.
Table or TreeView Table controls populated programmatically.
single-selection or multi-selection controls.
Reminder Multi-selection is not available for Table control fields in "Server" mode.

This function is available for Table controls in "Server" and "Server + AJAX" mode, and for TreeView Table controls.

This function is available for Table controls in "Browser" mode only.

The TreeView Table control is not available.

Characteristics of the row elements

To modify the value of an element in a row, use the following syntax:
TableControl.ColumnName[RowIndex] = NewValue
If an element corresponds to the result of a calculation, enclose the numerical expression in brackets.
For example:
```
TABLE_TableCalcul.ModifieLigne((53+29),(83-21))
```

Table field/Hierarchical file table: Changes to the linked data file

If the cascading input is enabled, the data file linked to the control is automatically modified when the user goes to the next row.
If the cascading input is not enabled, the data file linked to the control is not modified. To write the content of the modified row to the linked data file, <Table>.Save must be used after <Table>.ModifyLine.

Remarks:

The "Cascading input" option can be selected in the "Details" tab of the control description.
Cascading input is only available on Table control Ajax file fields.

Changes in a Table or TreeView Table control based on a data file

To modify a row in a Table or TreeView Table control based on a data file, we advise you to:

modify the record in the data file with <Source>.Modify,
use <Table>.Display to refresh the control.

Component: wd300obj.dll