PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
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
Versions 16 and later
WINDEVLinux Most of these functions are now available in the WINDEV applications for Linux.
New in version 16
WINDEVLinux Most of these functions are now available in the WINDEV applications for Linux.
WINDEVLinux Most of these functions are now available in the WINDEV applications for Linux.
Versions 19 and later
WEBDEV - Browser code Most of these functions are now available in browser code.
New in version 19
WEBDEV - Browser code Most of these functions are now available in browser code.
WEBDEV - Browser code Most of these functions are now available in browser code.
Versions 20 and later
Android Most of these functions are now available for the Android applications.
iPhone/iPad Most of these functions are now available for the iPhone/iPad applications.
New in version 20
Android Most of these functions are now available for the Android applications.
iPhone/iPad Most of these functions are now available for the iPhone/iPad applications.
Android Most of these functions are now available for the Android applications.
iPhone/iPad Most of these functions are now available for the iPhone/iPad applications.
The following functions are used to manage the Table controls:
BuildBrowsingTableCreates a Table control from the items found in a data file (view or query).
FileToMemoryTableFills a "Memory table" control with all the records found in a data file, a HFSQL view or a query (query created in the query editor or by HExecuteSQLQuery).
TableAddAdds a row into:
  • a Table control,
  • a TreeView Table control,
  • a table displayed in a Combo Box control.
TableAddColumnAdds elements on the right of an Horizontal Table control.
TableAddInProgressModifies or returns the visibility status of internal wait window when adding additional elements into an infinite Table control.
TableAddLineAdds a row into
  • a Table control,
  • a TreeView Table control
TableAddLineWithAnimationAdds a row into a Table control or into a TreeView Table control with an animation.
TableAddTitleHeaderAdds a title-header of columns into a Table control or into a TreeView Table control found in a window.
TableAdjustAdjusts the title and size of columns found in a Table or TreeView Table control.
TableBreakSubscriptReturns the subscript of the break header and footer for a given break in a Table control.
TableCellSelectReturns the coordinates (row number and column number) of a selected cell. This function is kept for backward compatibility. We recommend that you use TableSelect.
TableCellSelectOccurrenceReturns the number of selected cells found in a Table control. This function is kept for backward compatibility. We recommend that you use TableSelectCount.
TableColumnSelectReturns the column number corresponding to one of the columns selected in the Table control. This function is kept for backward compatibility. We recommend that you use TableSelect.
TableColumnSelectOccurrenceReturns the number of selected columns found in a table. This function is kept for backward compatibility. We recommend that you use TableSelectCount.
TableColumnSubscriptReturns the subscript of a column found in a Table or Treeview Table control.
TableCountReturns:
  • the number of columns found in a Table or Treeview Table control.
  • the number of rows found in a Table or TreeView Table control.
TableDeleteDeletes a row from:
  • a Table control,
  • a TreeView Table control,
  • a table displayed in a Combo Box control.
TableDeleteAllDeletes all the rows from:
  • a memory Table control,
  • a memory TreeView Table control,
  • a table displayed in a Combo Box control.
TableDeleteSelectDeletes the selected rows from a Table or Treeview Table control.
TableDeleteWithAnimationDeletes a row from a Table control, from a TreeView Table control (or from a table displayed in a Combo Box control) with an animation.
TableDisableFilterDisables a user filter on a column or on all the columns found in a Table or TreeView Table control.
TableDisplayRefreshes the display of a Table or TeeeView Table control from a given position:
  • a Browsing Table control: the modifications performed in the linked data file are applied to the control.
  • a memory Table control: the calculated columns are re-calculated.
TableEnableFilterImplements a user filter on a column found in a Table or TreeView Table control.
TableEndStops the manual browse of data file linked to a browsing Table control.
TableEndFillingIndicates the end of fill for a memory Table or TreeView Table control.
TableEnumBreakEnumerates the breaks found in a Table control.
TableEnumColumnReturns the name of a column found in a Table or Treeview Table control.
TableFilteredColumnReturns the list of columns filtered by the user in a Table or TreeView Table control.
TableFixColumnFixes a column to the left or frees a column fixed to the left.
TableFormulaAddAdds a calculated row into a Table control by providing the procedures for custom calculations.
TableFormulaDeleteAllDeletes all the rows added by TableFormulaAdd.
TableInfoXYReturns 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 subscript of the row or column for the specified position.
TableInputInProgressIndicates whether a Table or Treeview Table control is currently in edit.
TableInputSearchSwitches to input mode the search area found in the column title of the Table or Treeview Table control .
TableInsertInserts a row into:
  • a Table control,
  • a TreeView Table control,
  • a table displayed in a Combo Box control.
TableInsertColumnInserts elements in the format of columns into an horizontal Table control.
TableInsertLineInserts a row into
  • a Table control,
  • a TreeView Table control
TableInsertLineWithAnimationInserts a row into a Table control or into a TreeView Table control with an animation.
TableModeTableMode is kept for backward compatibility.
TableModifyModifies a row in:
  • a Table control,
  • a TreeView Table control,
  • a table displayed in a Combo Box control.
TableModifyColumnModifies a column in an horizontal Table control.
TableModifyLineModifies a row in:
  • a Table control,
  • a TreeView Table control.
TableMoveColumnMoves a column in a Table or TreeView Table control.
TableMoveLineMoves a row or swaps two rows in a Table control.
TablePositionDisplays a Table or TreeView Table control from a specified row or returns the subscript of first row displayed in a Table or TreeView Table control.
TablePrintPrints the content of the specified Table control without having to create a report based on the Table control.
TableRecNumReturns the number of the current record in a browsing Table control.
TableRefreshVisibleModifies or returns the visibility status of refresh bar in a Table or TreeView Table control.
TableRestorePositionAndSelectionRestores the scrollbar position in a Table or TreeView Table control as well as the selected elements.
TableSaveModifies or adds the record associated with the current row in the browsing Table or browsing TreeView Table control.
TableSavePositionAndSelectionSaves:
  • the scrollbar position in a Table or TreeView Table control,
  • the elements selected in the control.
TableSeekPerforms a search in:
  • a Table control,
  • a TreeView Table control,
  • a table displayed in a Combo Box control.
TableSelectReturns the subscript of the element selected in the Table or TreeView Table control.
TableSelectCountReturns the number of elements selected in a Table or Treeview Table control (notably in the case of a multi-selection control).
TableSelectMinusDeselects a row from a Table or Treeview Table control.
TableSelectPlusSelects a row in a Table or TreeView Table control.
TableSelectToFilePositions on the data file record corresponding to the row selected in the multi-selection browsing Table control.
TableSetFocusGives focus to a row found in a Table or Treeview Table control: the control switches to edit for the specified row and column.
TableSortSorts a Table or Treeview Table control on one or more columns (lexicographical sort).
TableSort_55TableSort_55 is kept for backward compatibility .
TableSortedColumnReturns the list of sorted columns found in a table.
TableStartFillingIndicates the start of fill for a memory Table or TreeView Table control.
TableSwapLineSwaps:
  • two rows in a memory Table control.
  • two branches in a memory Treeview Table control.
TableToClipboardCopies the content of a Table or TreeView Table control into the clipboard.
TableToExcelCreates an Excel file from the data found in a Table or Treeview Table control .
TableToTextCreates a character string from the data found in a Table or TreeView Table control.
TableToWordCreates a Word file (.RTF) from the data found in a Table or Treeview Table control.
TableToXMLCreates an XML file from the data found in a Table or TreeView Table control .
Other functions can also be used to handle the Table controls:
CurrentSubscriptReturns the number of the current row displayed in the current Table control.
NextSubscriptReturns the number of the next row displayed in the current Table control.
Minimum required version
  • Version 9
This page is also available for…
Comments
Exemplo Tabela com Descrição em Varias Linhas
Exemplo Tabela com Descrição em Varias Linhas

Nessa aula vou mostrar como mostrar numa coluna um nome completo na coluna

This lesson will show how to show a full name column column

Cette leçon va vous montrer comment afficher une colonne de la colonne de nom complet

// Blog com video e exemplo
http://windevdesenvolvimento.blogspot.com.br/2016/06/curso-windev-tabela-028-tabela.html
https://www.youtube.com/watch?v=NZ9ZG-RP9NU

De matos AMARILDO
Jun. 09 2016
Tabela - Colorir Linha

//Displaying a row of table_pedido
IF TABLE_pedido.COL_Valor_total>=0 AND TABLE_pedido.COL_Valor_total<=10
TABLE_pedido[CurrentSubscript()]..Color=DarkBlue
END
IF TABLE_pedido.COL_Valor_total>=11 AND TABLE_pedido.COL_Valor_total<=100
TABLE_pedido[CurrentSubscript()]..Color=LightBrown
END
IF TABLE_pedido.COL_Valor_total>101
TABLE_pedido[CurrentSubscript()]..Color=LightRed
END

//Blog com video e exemplo
http://windevdesenvolvimento.blogspot.com.br/2016/04/curso-windev-tabela-026-tabela-break.html
De matos AMARILDO
Apr. 25 2016
Tabela com Break/Totalizadores

//Displaying a row of brk_breakfooter1
r_total is real
FOR i=TableBreakSubscript(BRK_BreakHeader1) TO TableBreakSubscript(BRK_BreakFooter1)
r_total+=TABLE_pedido.COL_Valor_total[i]
END
TABLE_pedido[TABLE_pedido].EDT_TotalDia=r_total

//Blog com video e exemplo
http://windevdesenvolvimento.blogspot.com.br/2016/04/curso-windev-tabela-026-tabela-break.html
De matos AMARILDO
Apr. 25 2016
Exemplo Total Automatico ou Manual
Exemplo Total Automatico ou Manual

//soma Manual
EDT_soma=TABLE_pedido.COL_Valor_total[rowTotal]

//Blog com Video e exemplo
http://windevdesenvolvimento.blogspot.com.br/2016/04/curso-windev-tabela-024-somar-valor.html
De matos AMARILDO
Apr. 22 2016