PC SOFT

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • Overview of Table control
  • How to?
  • Creating a Table control
  • Characteristics of Table control
  • Tips
  • Vocabulary
  • Swapping
  • Table/Looper control
  • Limits
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:
    • Browsing Table controls with direct access: the browsing Table control directly handles the records found in the query or in the data file.
    • Browsing Table controls loaded in memory: the browsing Table control handles the data file records loaded in memory (optimized browsing Table control).
See the comparison between the features of Table controls for more details.
Notes:
  • WEBDEV - Server codeWEBDEV - Browser code The Table controls can be multiselection
  • WEBDEV - Server codeWEBDEV - Browser code You can create Table controls with different operating modes:
    • Table control in classic mode.
    • AJAX Table control. See AJAX Table control for more details.
    • Versions 19 and later
      Table control in browser mode.
      New in version 19
      Table control in browser mode.
      Table control in browser mode.
Versions 16 and later
Linux The Table control is now available in Linux for WINDEV.
New in version 16
Linux The Table control is now available in Linux for WINDEV.
Linux The Table control is now available in Linux for WINDEV.
How to?

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:
    • 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.
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 Table control

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

    Tips

    • 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. Display the description window of Table control.
      2. Select the column to duplicate.
      3. Click "Duplicate".
      New in version 15
      You have the ability to quickly duplicate a column. To do so:
      1. Display the description window of Table control.
      2. Select the column to duplicate.
      3. Click "Duplicate".
      You have the ability to quickly duplicate a column. To do so:
      1. Display the description window of Table control.
      2. Select the column to duplicate.
      3. Click "Duplicate".
      You have the ability to quickly duplicate a column. To do so:
      1. Display the description window of Table control.
      2. Select the column to duplicate.
      3. Display the popup menu of the column and select "Duplicate column"'.
        Note: This option is also available in the "New" drop-down menu.
    Note: The height specified for the first row of the Table control is applied to all other control rows.
    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 (via 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 "Control .. Swap .. Table to Looper".On the "Modification" pane, in the "Transformations" group, expand "Refactoring and swapping" and select "Table to Looper".
    Limits
    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
    See also
    Minimum version required
    • Version 9
    This page is also available for…
    Comments
    BUTTON_ALLCHECK & BUTTON_NOTCHECK
    CLICK WITH MOUSE RIGHT
    DESCRIPTION TABLE
    ADD COLUMN
    IN TABLE WITH OPTION ALTER TEXT
    TO CHECK AND OK

    IN

    BUTTON_ALLCHECK
    //MARCAR TUDO
    X, TOTAL is int
    TOTAL = TABLEGRID_T001_perguntas.Count(toTotal)
    LOOP(TOTAL)
    X++
    TABLEGRID_T001_perguntas[X].COL_CHECK = False
    END


    BUTTON_NOTCHECK
    //DESMARCAR TUDO
    X, TOTAL is int
    TOTAL = TABLEGRID_T001_perguntas.Count(toTotal)
    LOOP(TOTAL)
    X++
    TABLEGRID_T001_perguntas[X].COL_CHECK = False
    END
    BOLLER
    20 Aug. 2019
    Video Table
    https://youtu.be/f61REupbO1E

    https://windevdesenvolvimento.blogspot.com/2019/06/dicas-2149-windev-webdev-mobile-tabela.html

    // BTN_GERAR_TABELA
    TableDeleteAll(TABLE_CLIENTE_B)
    FOR EACH cliente
    //TableAddLine(TABLE_CLIENTE_B,CLIENTE.clienteid,CLIENTE.nome)
    nPOSICAO is int=TableAddLine(TABLE_CLIENTE_B)
    TABLE_CLIENTE_B[nPOSICAO].COL_CODIGO=cliente.clienteid
    TABLE_CLIENTE_B[nPOSICAO].COL_NOME=cliente.nome
    END
    amarildo
    10 Jun. 2019
    Video Tabela Editavel
    Tabela Editavel

    https://youtu.be/IVZVVom1UVM

    https://windevdesenvolvimento.blogspot.com/2019/05/dicas-2128-windev-webdev-mobile-tabela.html
    amarildo
    29 May 2019
    Video Table
    https://youtu.be/mKqFg2NuHZc

    https://windevdesenvolvimento.blogspot.com/2019/05/dicas-2098-windev-webdev-mobile-tabela.html
    // ENTRY IN EDT_TIPO_CARTAO_NUMERO

    TABLE_RELACAO_FORMA_PAGAMENTO..Visible=True

    // EXIT IN EDT_TIPO_CARTAO_NUMERO

    TABLE_RELACAO_FORMA_PAGAMENTO..Visible=False

    amarildo
    05 May 2019
    Nao Aparecer Zeros Colunas
    https://youtu.be/ahAuEBUCHLE

    https://windevdesenvolvimento.blogspot.com/2019/04/dicas-2070-windev-mobile-webdev-tabela.html

    amarildo
    09 Apr. 2019
    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
    25 Jun. 2018
    Altura Linha Tabela
    Altura Linha Tabela

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

    https://groups.google.com/d/forum/amarildowindev
    De matos
    18 May 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
    05 Aug. 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
    14 May 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
    21 Feb. 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
    18 Mar. 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
    13 Mar. 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
    11 Mar. 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
    08 Mar. 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
    02 Mar. 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
    29 Feb. 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
    26 Jan. 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
    26 Jan. 2016