PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview of Table control
  • How to proceed?
  • Creating a Table control
  • Characteristics of a Table control
  • Tips
  • Vocabulary
  • Swapping
  • Table/Looper control
  • TreeView Table/Table control
  • Limits
  • Limits for Java
  • Limits for Android
  • Limits for iOS
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
Overview of Table control
The Table control is used to simplify the display and the input of information stored in memory or coming from a data file, a view or a query.
A Table control is contains rows and columns. The intersection between a row and a column defines a cell.
A Table control can be managed row by row, column by column or cell by cell. A Table control can be displayed horizontally or vertically.
The information displayed in a Table control can:
  • be defined by programming: we talk of Memory Table control.
  • come from a variable: we talk of Table on source control.
  • come from a data file or from a query: we talk of Browsing Table control. Two types of browsing Table controls are available:
    • The browsing Table controls with direct access: the browsing Table control directly handles the records found in the query or in the data file.
    • The browsing Table controls loaded in memory: the browsing Table control handles the file records loaded in memory (optimized browsing Table control).
Notes:
Versions 16 and later
WINDEVLinux The Table control is now available in Linux for WINDEV.
New in version 16
WINDEVLinux The Table control is now available in Linux for WINDEV.
WINDEVLinux The Table control is now available in Linux for WINDEV.
Versions 20 and later
Android The Table control is now available for the Android applications.
iPhone/iPad The Table control is now available for the iPhone/iPad applications.
New in version 20
Android The Table control is now available for the Android applications.
iPhone/iPad The Table control is now available for the iPhone/iPad applications.
Android The Table control is now available for the Android applications.
iPhone/iPad The Table control is now available for the iPhone/iPad applications.
How to proceed?

Creating a Table control

To create a Table control:
  1. In the window or page editor, click (or select "Insert .. Control .. Table").On the "Creation" pane, in the "Data" group:
    • WINDEV expand "Table and list box" and select "Table (Vertical)".
    • WINDEV Mobile expand "Table" and select "Table (Vertical)".
    • WEBDEV - Server code expand "Table" and select "Table".
  2. Click the position where the control will be created in the window or page. The wizard for creating a Table control is automatically started.
  3. Answer the questions and validate the control creation.
WINDEVWINDEV Mobile
Versions 20 and later
Note: The dimensions of created control are optimized in order to occupy the available space at the specified position. If the control size does not suit your, press [CTRL + Z]: the default control size will be restored.
New in version 20
Note: The dimensions of created control are optimized in order to occupy the available space at the specified position. If the control size does not suit your, press [CTRL + Z]: the default control size will be restored.
Note: The dimensions of created control are optimized in order to occupy the available space at the specified position. If the control size does not suit your, press [CTRL + Z]: the default control size will be restored.
To display the control characteristics, select "Description" from the popup menu of control. Two types of information can be viewed:
  • the information regarding the entire Table control (all you have to do is select the name of the control).
  • the information regarding each of the columns (all you have to do is select the name of a column).
Notes:
  • To easily create a browsing Table control from a data file described in the data model editor, all you have to do is Drag and Drop the selected data file into the "Project explorer" pane or into the "Analysis" pane.
  • To easily create a Table control on source from array variables found in the current window or in the current page, all you have to do is Drag and Drop the selected variable into the "Project explorer" pane.

Characteristics of a Table control

In the characteristics of a Table control, you have the ability to specify:
For more details, see:

Tips

  • WINDEVWINDEV Mobile To add new columns in a Table control, use the popup menu of control in the window editor. The "Add a column..." option allows you to add into the selected control a new column of the requested type after the existing columns.
  • The height of the rows in the Table control is too small in the editor? all you have to do is use the mouse to increase the height of the table rows. This trick is very useful for the multiline columns and the container columns.
Versions 15 and later
  • You have the ability to quickly duplicate a column. To do so:
    1. Open the description window of Table control.
    2. Select the column to duplicate.
    3. Click the "Duplicate" button.
New in version 15
  • You have the ability to quickly duplicate a column. To do so:
    1. Open the description window of Table control.
    2. Select the column to duplicate.
    3. Click the "Duplicate" button.
  • You have the ability to quickly duplicate a column. To do so:
    1. Open the description window of Table control.
    2. Select the column to duplicate.
    3. Click the "Duplicate" button.
Note: The height specified for the first row of the Table control is applied to all the other rows of the control.
Vocabulary
To easily handle a Table control, you must be familiar with the following vocabulary:
NameDefinition
Selection barUsed to view the selected element. A specific color is used in most cases.
Browsing Table controlThe Table control is based on a data file or on a query. The control elements correspond to the file records.
Memory Table controlThe Table control is not based on a data file or on a query. The elements displayed in the control are defined by the developer (by programming).
Single-selection Table controlThe user can select a single element in the Table control.
Multiselection Table controlThe user can select several elements at the same time in the Table control (with the CTRL key).
Table on source controlThe Table control is based on a WLanguage variable. The elements displayed in the control correspond to the data found in the variable.
Swapping

Table/Looper control

A Table control can be automatically transformed into a Looper control:
  1. Select the Table control to transform.
  2. Select the "Control .. Swap .. Table to Looper" option.On the "Modification" pane, in the "Transformations" group, expand "Refactoring and swapping" and select "Table to Looper".
WINDEVWindows MobileJava

TreeView Table/Table control

WINDEV and WINDEV Mobile allow you to automatically transform a Table control into a TreeView Table control (and conversely):
  1. Select the Table control (or the TreeView Table control) to handle.
  2. Select "Control .. Swap .. Table/Treeview Table".On the "Modification" pane, in the "Transformations" group, expand "Refactoring and swapping" and select "Table/TreeView Table".
Limits
Java

Limits for Java

The following characteristics are not supported in Java:
  • automatic calculation in the columns of a Table control.
  • tooltip of the vertical scrollbar.
  • proportional scrollbar.
  • lock of records currently modified.
  • column fixed to the left.
  • ellipsis mode in the text columns.
Android

Limits for Android

  • The Table controls on source are not available.
iPhone/iPad

Limits for iOS

  • The Table controls are available in read-only: the input is not available in this version.
  • The Table controls on source are not available.
Related Examples:
The memory Table control Unit examples (WINDEV): The memory Table control
[ + ] Using a memory table in an application:
- Clear a memory table
- Fill a row in the memory table
- Select a row
- Sort a memory table
- Delete a row from the memory table
The Table/TreeView Table control (Progress Bar columns) Unit examples (WINDEV): The Table/TreeView Table control (Progress Bar columns)
[ + ] Using a Progress Bar column as well as the ..TextProgressBar property in a Table or TreeView Table control
WD DataBinding Training (WINDEV): WD DataBinding
[ + ] The "WD DataBinding" example explains how to link a control and a WLanguage variable.

This example includes two windows:
- A first window presents a simple link between the controls and a composite variable.
- A second window presents a link between a table control and a WLanguage class as well as the link between the table and a detailed form
The Ajax Table control Unit examples (WEBDEV): The Ajax Table control
[ + ] This example explains how to use the Ajax tables. This example allows you to:
- Access the content of a table element in browser code
- Clear the table
- Fill the table
- Select a row
- Sort the table
- Delete the selected row
The Ajax Table control in PHP Unit examples (WEBDEV): The Ajax Table control in PHP
[ + ] This example explains how to use the Ajax tables in PHP.
The following topics are explained:
- Access the content of a table element in browser code (using the AjaxExecuteAsynchronous function)
- Delete the table content
- Fill the table
- Select a row
- Delete a row
The memory Table control Unit examples (WEBDEV): The memory Table control
[ + ] This example explains how to use a memory table in a WEBDEV application and it allows you to:
- Clear a memory table
- Fill a row in the memory table
- Select a row
- Sort a memory table
- Delete a row from the memory table
The memory Table control Unit examples (WINDEV Mobile): The memory Table control
[ + ] Using a memory table in an application:
- Clear a memory table
- Fill a row in the memory table
- Select a row
- Sort a memory table
- Delete a row from the memory table
Pocket Attendance Mobile (WINDEV Mobile): Pocket Attendance
[ + ] This application is an attendance manager. It allows you to list the persons who attended a meeting.
The database is previously filled with the list of registered persons.
A bar code reader can be used to read the identifiers of the persons.
The following topics are presented in this example:
1/ the click performed on a table column
2/ the use of a browsing table
Minimum required version
  • Version 9
This page is also available for…
Comments
Table with column dinamic add
FiltraUsuarios("")

//AlteraNomeColunasQuery("TABLE_usuario","QRY_Select_All_Usuarios")

//usando a estrutura da query
sColuna is string = pTableNameControl+".COL_Column"
ItemList is string = HListItem( {pQueryName,indFile} , hLstDetail)
CountCampos is int = StringCount(ItemList,CRLF)

//c is int
//
//loop (CountCampos)
// c+=1
//
// //TableInsertColumn /// windev
//
//END


ItemList = Replace(ItemList,CRLF,";")
ItemList = Replace(ItemList,TAB,";")
x is int = 6
y is int = 0
VARTEXT is string
LOOP(CountCampos)
y+= 1
VARTEXT = ExtractString(ItemList,x,";",FromBeginning)
{sColuna+y,indControl}..Caption = VARTEXT
{sColuna+y,indControl}..Visible = True
x+= 6
END
BOLLER
Jun. 25 2018
Altura Linha Tabela
Altura Linha Tabela

https://youtu.be/fhBPFSZ--gc

https://groups.google.com/d/forum/amarildowindev
De matos
May 18 2018
COLORIR COLUNA TABELA
TABLE_Empresa..Color=DarkGreen
TABLE_Empresa[2]..Color=LightBlue
TABLE_Empresa[2][2]..Color=LightMagenta
TABLE_Empresa..BrushColor=Bronze
TABLE_Empresa[1][1]..BrushColor=RGB(0, 255, 61)
TABLE_Empresa[TABLE_Empresa][2]..Color=Bronze

// BLOG COM VIDEO E EXEMPLO

http://windevdesenvolvimento.blogspot.com.br/2017/08/aula-1232-windev-tabela-colorir-1-coluna.html

https://www.youtube.com/watch?v=tWU3l2fB6ME


De matos
Aug. 05 2017
Let's set up the business table,
[Video Aulas Amarildo] Aula 1149 WinDev Curso ErpAmarildo 7 - Tabela de Empresas Fazer


Nessa aula de hoje
vamos montar a tabela de empresas,
em cima da query. primeiro vou fazer
ele fazer automatico a tabela e depois
vou alterar ela

In this class today
Let's set up the business table,
On top of the query. I'll do it first.
It does the table automatically and then

En esta clase de hoy
En el caso de las empresas,
Sobre la consulta. Primero voy a hacer
Hacer automáticamente la tabla y después
Voy a cambiarla


https://forum.pcsoft.fr/pt-BR/pcsoft.br.windev/2373-video-aulas-amarildo-aula-1149-windev-curso-erpamarildo/read.awp

https://doc.windev.com/en-US/?1013224&name=Table_control

http://windevdesenvolvimento.blogspot.com.br/2017/05/aula-1149-windev-curso-erpamarildo-7.html

https://www.youtube.com/watch?v=Z2ienJCvNlM
De matos
May 14 2017
Tabela borda
// Vou Mostrar como Alterar a Borda Via programacao.
// vou Fazer um colando borda na coluna de uma linha
// da tabela

_configura is a Border
_configura..Thickness = 2 // Espessura
_configura..Color = PastelRed // Cor
_configura..LineBottom..Color = DarkRed // Cor Linha Inferir
_configura..LineBottom..Type =LineDash // Tipo Linha

TABLE_indices[3].COL_Valor..Border = _configura
LIB_observacao..Border=_configura
Info("Continua.. Outras Configurações")

//Outras Configurações
_configura..Round=4 // Borda Arredondada

_configura..Line=TraitTiret // Tipo Da Linha

_configura..Edges=BorderBottom // Borda tem somente inferior

TABLE_indices[3].COL_Valor..Border = _configura
LIB_observacao..Border=_configura

// Blog com Video E Exemplo

http://windevdesenvolvimento.blogspot.com.br/2017/02/aula-1057-windev-tabela-042-border.html

https://www.youtube.com/watch?v=ljp4A2Jg2RU
De matos
Feb. 21 2017
Exemplo tabela - Muda Nome Sum
Nessa aula vou mostrar como mudar o nome do Sum na Tabela
This class will show you how to rename the Sum in Table
Cette classe va vous montrer comment renommer la somme dans le tableau

//Blog com Video e Exemplo
http://windevdesenvolvimento.blogspot.com.br/2016/03/curso-windev-tabela-016-tabela-sum-como.html
De matos AMARILDO
Mar. 18 2016
Exemplo Tabela com Contrainer
Exemplo Tabela com Contrainer

//Blog com video e Exemplo Tabela com Contrainer
http://windevdesenvolvimento.blogspot.com.br/2016/03/curso-windev-tabela-015-tabela-coluna.html
De matos AMARILDO
Mar. 13 2016
Exemplo Tabela / ToolTip nas Colunas
TABLE_Cliente.COL_Email..ToolTip="Aqui é o Email "
TABLE_Cliente.COL_Nome..ToolTip="Aqui é o Nome da Pessoa"
TABLE_Cliente.COL_ClienteID..ToolTip="Aqui Codigo"

//Frances
TABLE_Cliente.COL_Email..Bulle="Aqui é o Email "
TABLE_Cliente.COL_Nome..Bulle="Aqui é o Nome da Pessoa"
TABLE_Cliente.COL_ClienteID..Bulle="Aqui Codigo"

//Blog com video e exemplo
http://windevdesenvolvimento.blogspot.com.br/2016/03/curso-windev-tabela-014-tabela-tooltip.html
De matos AMARILDO
Mar. 11 2016
Exemplo Tabela MultiSelecao
TABLE_Bancos..Multiselection=True

// Blog Com Video e Exemplo
http://windevdesenvolvimento.blogspot.com.br/2016/03/curso-windev-tabela-013-tabela.html
De matos AMARILDO
Mar. 08 2016
Tabela percorrer
FOR EACH ROW OF TABLE_Cliente
Trace(TABLE_Cliente.COL_Nome)
END

//frances
POUR CHAQUE LIGNE DE TABLE_Cliente
Trace(TABLE_Cliente.COL_Nome)
FIN

//blog com video e exemplo
http://windevdesenvolvimento.blogspot.com.br/2016/03/curso-windev-tabela-012-for-each-row-of.html
De matos AMARILDO
Mar. 02 2016
Table Zoom
TABLE_Cliente..Zoom=200
//Blog com Video e Exemplo Zoom
http://windevdesenvolvimento.blogspot.com.br/2016/02/curso-windev-tabela-011-zoom.html
De matos AMARILDO
Feb. 29 2016
Exemplo tabela altera cor e fundo da coluna
TABLE_cliente.COL_cnpj_cpf..Color=DarkMagenta // alterar cor
TABLE_cliente.COL_nome_fantasia..BrushColor=DarkCyan //alterar fundo
//frances
TABLE_municipios.COL_Nome_pais..Couleur=BleuClair // color =ingles
TABLE_municipios.COL_Estado..CouleurFond=BleuPastel // brushcolor = ingles

//Blog com video e exemplo
http://windevdesenvolvimento.blogspot.com.br/2016/01/curso-windev-tabela-003-mudar-cor-e.html
De matos AMARILDO
Jan. 26 2016
Exemplo Tabela Altera Coluna Fonte e Largura
TABLE_cliente.COL_Data_cadastro..FontBold=True // alterar tipo
TABLE_cliente.COL_id_empresA_representante..FontLarge=True //alterar tamanho
//frances
TABLE_municipios.COL_Nome_pais..PoliceGras=Vrai // fontbold = true
TABLE_municipios.COL_Codigo_pais..PoliceLarge=Vrai // fontlarge=true
//Blog com Video e Exemplo
http://windevdesenvolvimento.blogspot.com.br/2016/01/curso-windev-tabela-004-mudar-largura-e.html
De matos AMARILDO
Jan. 26 2016