PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • Use conditions
  • Characteristics of a row
  • Position of added row
  • Limits: Maximum number of rows displayed
  • Various
  • Adding rows
  • Cascading input
  • Browsing Table or TreeView Table control: Modifications in the linked data file
  • Browsing Table or TreeView Table control: Adding several rows
  • Adding a record into a browsing Table control and releasing a trigger
  • Adding images
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
Adds a row into:
  • a Table control,
  • a TreeView Table control,
Note: It is recommended to use <Table>.AddLine. <Table>.AddLine is used to add:
  • TAB characters into the columns,
  • all types of values into the columns.
Versions 18 and later
WEBDEV - Server codePHP This function can now be used to handle the TreeView Table controls in the WEBDEV and PHP sites.
New in version 18
WEBDEV - Server codePHP This function can now be used to handle the TreeView Table controls in the WEBDEV and PHP sites.
WEBDEV - Server codePHP This function can now be used to handle the TreeView Table controls in the WEBDEV and PHP sites.
Versions 19 and later
WEBDEV - Browser code This function is now available in Browser code for Table controls in browser mode.
New in version 19
WEBDEV - Browser code This function is now available in Browser code for Table controls in browser mode.
WEBDEV - Browser code This function is now available in Browser code for Table controls in browser mode.
Example
// Add "Moore", "Vince" and "06/21/72"
// at the end of the "TABLE_CustomerTable" control
ResAdd = TABLE_CustomerTable.Add("Moore" + TAB + "Vince" + TAB + "06/21/72")
Syntax
<Result> = <Table control>.Add([<Row>])
<Result>: Boolean
  • True if the element was added,
  • False otherwise.
<Table control>: Control name
Name of control to use. This control can correspond to:
  • a Table control.
  • a TreeView Table control.
<Row>: Optional character string
Row to add. This row has the following format:
<Element of column 1> + TAB + <Element of column 2> + TAB + ...

If this parameter is not specified, an empty row is added into the control. For a browsing control, the default values defined in the linked data file are taken into account.
Remarks

Use conditions

<Table>.Add can be used on:
  • a browsing or memory control,
  • a single-selection or multiselection control.
    WEBDEV - Server codePHP Reminder: Multiselection controls are available in Ajax only WEBDEV - Server codePHP Reminder: Multiselection is not available for Table controls in classic mode.
WEBDEV - Server codePHP This function is available for Table controls in Ajax mode, Table controls in classic mode and TreeView Table controls.
WEBDEV - Browser code This function is available for Table controls in browser mode only.
WEBDEV - Browser code The TreeView Table control is not available.

Characteristics of a row

  • Each added element is converted into the type of the relevant column.
  • To specify no value for an element, use an empty string ("") or 0 (according to the type of column). For example:
    TABLE_CustomerTable.Add("Moore" + TAB + "Vince" + TAB + "" + TAB + "06/21/72")
  • If an element corresponds to the calculation result, the numeric expression must be enclosed in brackets. For example:
    TABLE_CalculationTable.Add((53+29) + TAB + (83-21))

Position of added row

By default, the row is added at the end of the rows displayed by the control.
Special case:
  • If the control is sorted by <Table>.Sort, the added row is positioned in the control according to the current sort.
  • If the control is sorted by the user, the sort is ignored when inserting the row. The row is added at the end of control.

Limits: Maximum number of rows displayed

The maximum number of rows that can be displayed in a Table or TreeView Table control is limited by the amount of available memory (theoretical maximum: 2 billion rows).
However, we do not advise you to use large Table or TreeView Table controls for performance and user-friendliness reasons (time required to fill the control for example).

Various

  • To add a row at a specific position in a Table or TreeView Table control, use <Table>.InsertLine.
  • If the added row is the first row of the control, the added row becomes the current row.
WEBDEV - Server codePHP

Adding rows

..NewLine is used to find out whether the current row was just created by <Table>.Add (..NewLine = True).
WEBDEV - Server codePHP

Cascading input

To perform a cascading input, <Table>.Add must be used in the event "Exit from a row" of the Table control:
IF TABLE_CustomerTable..NewLine THEN
TABLE_CustomerTable.Add()
END
WEBDEV - Server codePHP This operating mode is available for Table controls in Ajax mode only.
WEBDEV - Server codePHP

Browsing Table or TreeView Table control: Modifications in 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 row added in the linked data file, <Table>.Save must be used after <Table>.Add.
Notes:
  • The "Cascading input (Addition)" option can be selected in the "Details" tab of the control description.
  • Versions 19 and later
    WEBDEV - Server code The cascading input is available for the Ajax browsing Table controls only.
    New in version 19
    WEBDEV - Server code The cascading input is available for the Ajax browsing Table controls only.
    WEBDEV - Server code The cascading input is available for the Ajax browsing Table controls only.
WEBDEV - Server codePHP

Browsing Table or TreeView Table control: Adding several rows

A virtual row is created in the control whenever <Table>.Add is called in a browsing Table or TreeView Table control. The information will be saved in the linked data file only when <Table>.Save is called.
If <Table>.Add is successively called in the same process without being followed by <Table>.Save, only the FIRST call is effective (the following calls are ignored). A single row is added into the browsing Table or TreeView Table control.
WEBDEV - Server codePHP This operating mode is available for the browsing Ajax Table controls only.
WEBDEV - Server code

Adding a record into a browsing Table control and releasing a trigger

You have the ability to release a trigger when a record is added into a browsing Table control. See the documentation about HDescribeTrigger for more details.
WEBDEV - Server code This operating mode is available for the browsing Ajax Table controls only.

Adding images

To add an image into a Table or TreeView Table control:
  • WEBDEV - Server codePHP specify the path and name of image to add. The path is relative to the "<Project_Name>_WEB" directory.
    For example:
    // Adds the image found in the "WB_MyApp_WEB" directory
    TABLE_MyTable.Add("MyImage.BMP")
Note: The column must be an Image column otherwise the added image will not be displayed properly.
Component : wd240obj.dll
Minimum version required
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment