PC SOFT

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • Characteristics of column elements
  • Browsing table: Modifications in the linked data file
  • Modifications performed in a browsing Table control
  • TableModifyColumn function and ..Modified property
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
TableModifyColumn (Function)
In french: TableModifieColonne
Modifies a column in an "horizontal Table" control.
Remark: TableModifyColumn can be used on:
  • a horizontal browsing or memory Table control.
  • a single-selection or multiselection Table control.
Versions 16 and later
WINDEVLinux This function is now available for WINDEV applications in Linux.
New in version 16
WINDEVLinux This function is now available for WINDEV applications in Linux.
WINDEVLinux This function is now available for WINDEV applications in Linux.
Syntax
TableModifyColumn(<Table control> , <Subscript> [, <Element row 1> [... [, <Element row N>]]])
<Table control>: Control name
Name of Horizontal Table control to use.
If this parameter corresponds to an empty string (""), the Table control used will be the one to which the current event belongs.
<Subscript>: Integer
Subscript of column to modify. The subscript of first column is set to 1.
Subscript equal to -1.The current column is modified. No effect if no column is selected.
Subscript greater than the number of columns in the Table control.A WLanguage error occurs.
<Element row 1>: Optional character strings
First elements of modified column. The values of these elements replace the existing values. Each element corresponds to a row in the Table control. Each type of modified element must be compatible with the type of the relevant row.
TableModifyColumn has no effect if none of these parameters is specified.
<Element row N>: Optional character strings
Nth elements of modified column. The values of these elements replace the existing values. Each element corresponds to a row in the Table control. Each type of modified element must be compatible with the type of the relevant row.
TableModifyColumn has no effect if none of these parameters is specified.
Remarks

Characteristics of column elements

  • To modify the value of an element in a column, use the following syntax:
    TableName.RowName[ColumnSubscript] = NewValue
  • If an element corresponds to the calculation result, the numeric expression must be enclosed in brackets. For example:
    TableModifyColumn(TABLE_CalcTable, (53+29),(83-21))

Browsing table: Modifications in the linked data file

If the cascading input is enabled, the data file linked to the browsing Table control is automatically modified when the user goes to the next column.
If the cascading input is not enabled, the data file linked to the browsing Table control is not modified. To write the record into the data file, TableSave must be run after TableModifyColumn.
Reminder: The "cascading input" option can be selected:
  • When creating a Table control.
  • In the "Details" tab of the description window of Table control in the window editor.

Modifications performed in a browsing Table control

To modify a column in a browsing Table control, we advise you to:

TableModifyColumn function and ..Modified property

TableModifyColumn has no influence on ..Modified. ..Modified is used to find out whether the current column was directly modified by the user (direct input in the Table control).
Component : wd250obj.dll
See also
Minimum version required
  • Version 12
This page is also available for…
Comments
Click [Add] to post a comment