ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Controls, pages and windows / Table functions
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
The following functions are used to manage Table controls, using prefix syntax:
<Table>.AddAdds a row in:
  • a Table control,
  • a TreeView Table control,
  • a Combo Box control "with table" (Table control displayed in a Combo Box control).
New in version SaaS
<Table>.AddBeginning
Adds a row at the top of an Infinite Table control. The row is inserted before the first row of the Table control. The scroll position of the Table control doesn't change.
<Table>.AddColumnAdds elements on the right of an Horizontal Table control.
<Table>.AddInProgressChanges or returns the visibility state of the internal wait window when additional elements are added to an infinite Table control.
<Table>.AddLineAdds a row in:
  • a Table control,
  • a TreeView Table control.
<Table>.AddLineWithAnimationAdds a row to a Table or TreeView Table control with an animation.
<Table>.AddTitleHeaderAdds a column title-header into a Table or TreeView Table control in a window.
<Table>.AdjustAdjusts the title and size of columns found in a Table or TreeView Table control.
<Table>.BreakIndexReturns the index of the break header and footer for a given break in a Table control.
<Table>.CellSelectReturns the coordinates (row number and column number) of a selected cell. This function is kept for backward compatibility. It is recommended to use TableSelect.
<Table>.CellSelectOccurrenceReturns the number of selected cells found in a Table control. This function is kept for backward compatibility. It is recommended to use TableSelectCount.
<Table>.CollapseExpandCollapses or expands an element in a Table or TreeView Table control.
<Table>.ColumnIndexReturns the index of a column in a Table or Treeview Table control.
<Table>.CountReturns:
  • the number of columns found in a Table or TreeView Table control.
  • the number of rows found in a Table or TreeView Table control.
<Table>.DeleteDeletes a row from:
  • a Table control,
  • a TreeView Table control,
  • a table displayed in a Combo Box control.
<Table>.DeleteAllDeletes all rows from:
  • a Table control populated programmatically,
  • a TreeView Table control populated programmatically,
  • tables displayed in a Combo Box control.
<Table>.DeleteSelectDeletes the selected rows from a Table or Treeview Table control.
<Table>.DeleteWithAnimationDeletes a row from a Table control, from a TreeView Table control (or from a table displayed in a Combo Box control) with an animation.
<Table>.DisableFilterDisables a user filter on a column or on all the columns found in a Table or TreeView Table control.
<Table>.DisplayRefreshes a Table or TeeeView Table control from a given position:
  • for a control linked to a file: changes made in the linked data file are reflected in the control.
  • for a control handled programmatically: the calculated columns are re-calculated.
<Table>.EndStops the manual iteration of data file linked to a Table control based on a data file.
<Table>.EndFillingEnds the process to populate a Table or TreeView Table control programmatically.
<Table>.EnumBreakEnumerates the breaks found in a Table control.
<Table>.EnumColumnReturns the name of a column found in a Table or Treeview Table control.
<Table>.FilteredColumnReturns the list of columns filtered by the user in a Table or TreeView Table control.
<Table>.FixColumnFixes a column to the left or frees a column fixed to the left.
<Table>.FormulaAddAdds a calculated row to a Table control by providing custom calculation procedures.
<Table>.FormulaDeleteAllDeletes all rows added with <Table>.FormulaAdd.
<Table>.fromJSONPopulates a Table or TreeView Table control with the contents of a JSON string or variable.
<Table>.InfoXYReturns for a given position in a Table or TreeView Table control (coordinates of a control point):
  • the name of the column displayed for the specified position.
  • the index of the row or column for the specified position.
<Table>.InputInProgressIndicates whether a Table or TreeView Table control is currently in edit.
<Table>.InputSearchEnables input in the search area in the column title of the Table or Treeview Table control.
<Table>.InsertInserts a row into:
  • a Table control,
  • a TreeView Table control,
  • a table displayed in a Combo Box control.
<Table>.InsertColumnInserts elements in the format of columns into a horizontal Table control.
<Table>.InsertLineInserts a row into:
  • a Table control,
  • a TreeView Table control.
<Table>.InsertLineWithAnimationInserts a row into a Table control or into a TreeView Table control with an animation.
<Table>.ModifyModifies a row in:
  • a Table control,
  • a TreeView Table control,
  • a table displayed in a Combo Box control.
<Table>.ModifyColumnModifies a column in a horizontal Table control.
<Table>.ModifyLineModifies a row in:
  • a Table control,
  • a TreeView Table control.
<Table>.MoveColumnMoves a column in a Table or TreeView Table control.
<Table>.MoveLineMoves a row or swaps two rows in a Table control.
<Table>.PositionDisplays a Table or TreeView Table control from a specified row or returns the index of the first row displayed in a Table or TreeView Table control.
<Table>.PrintPrints the content of the specified Table control without having to create a report based on the Table control.
<Table>.RecNumReturns the number of the current record in a Table control based on a data file.
<Table>.RefreshVisibleModifies or returns the visibility status of refresh bar in a Table or TreeView Table control.
<Table>.RestorePositionAndSelectionRestores the scrollbar position in a Table or TreeView Table control as well as the selected elements.
<Table>.SaveUpdates or adds the record bound to the current row in the Table or TreeView Table control.
<Table>.SavePositionAndSelectionSave:
  • the scrollbar position in a Table or TreeView Table control,
  • the elements selected in the control.
<Table>.SearchEverywhereSearches for a value in all the columns of the following controls:
  • Table control,
  • TreeView Table control,
  • Table control displayed in a Combo Box control.
<Table>.SelectReturns the index of the selected element in the Table or TreeView Table control.
<Table>.SelectCountReturns the number of selected elements in a Table or TreeView Table control (especially multi-selection controls).
<Table>.SelectMinusDeselects a row from a Table or TreeView Table control.
<Table>.SelectPlusSelects a row in a Table or TreeView Table control.
<Table>.SelectToFilePositions on the data file record corresponding to a row selected in the multi-selection Table control based on a data file.
<Table>.SetFocusGives focus to a row found in a Table or TreeView Table control: the control switches to edit for the specified row and column.
<Table>.SortSorts a Table or TreeView Table control on one or more columns (lexicographical sort).
<Table>.SortedColumnReturns the list of sorted columns found in a table.
<Table>.StartFillingStarts the process to populate a Table or TreeView Table control programmatically.
<Table>.SwapLineSwaps:
  • two rows in a Table control populated programmatically.
  • two branches in a Treeview Table control populated programmatically.
<Table>.ToClipboardCopies the content of a Table or TreeView Table control to the clipboard.
<Table>.ToExcelCreates an Excel file with the data from a Table or TreeView Table control.
<Table>.ToJSONConverts the contents of a Table or TreeView Table control to a JSON string.
<Table>.ToTextCreates a character string from the data found in a Table or TreeView Table control.
<Table>.ToWordCreates a Word file (.RTF) from the data found in a Table or TreeView Table control.
<Table>.ToXMLCreates an XML file from the data found in a Table or TreeView Table control.
Minimum version required
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/13/2024

Send a report | Local help