BuildBrowsingTable (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help

WLanguage

WLanguage functions

Controls, pages and windows

Characteristics of Table control (by default)

Memory Table control

Columns

Miscellaneous

See also

BuildBrowsingTable (Function)

In french: ConstruitTableFichier

Creates a Table control from the items of a data file (view or query). Each column of the control is bound to an item in the data file. The width of the columns changes automatically according to the data in the file or query.

This function is used to get a Table control adapted to the browse of a specific data file.

Versions 16 and later

This function is now available for WINDEV applications in Linux.

New in version 16

This function is now available for WINDEV applications in Linux.

Example

See additional examples

// Affiche le contenu du fichier "CLIENTS" dans un champ Table fichier
BuildBrowsingTable(TABLE_TABLE1, "CLIENTS", taWithAutoId)

// Affiche le contenu d'une requête dans un champ Table mémoire
IF HExecuteQuery(REQ_LISTE_CLIENTS_ACTIFS) = True THEN
BuildBrowsingTable(TABLE_CLIENTS, ...
REQ_LISTE_CLIENTS_ACTIFS, taFillTable)
END

Syntax

BuildBrowsingTable(<Table control> , <Data file> [, <Options>])

<Table control>: Control name

Name of Table control (browsing Table or memory Table).
Caution: This control must exist in the window.
Versions 19 and later
It may have been created by ControlCreate.
New in version 19
It may have been created by ControlCreate.
It may have been created by ControlCreate.
The records found the data file are directly viewed if this parameter corresponds to a browsing Table control.

<Data file>: Character string

Name of data file, view or query used as a base for creating the Table control.

<Options>: Optional constant (or combination of constants)

Configures the creation mode of columns in the Table control.
Operating mode with the constant Default operating mode
taWithBinary Binary items (link composite key for example) are added to the Table control. By default: Binary items (link composite key for example) are not added to the Table control.
taWithAutoId A column is generated for the automatic identifier. By default: No column for the automatic identifier.
Versions 23 and later
taWithDetailsBinding
New in version 23
taWithDetailsBinding
taWithDetailsBinding A sub-table is automatically generated to display the bound items from the data files of the analysis. By default: No "row details" window is displayed.
taKeepBrowseKey The search key of the browsing Table control does not change (this search key is returned by the BrowsedItem property). By default: The first key item found is positioned as search key.
taKeepColumn The existing columns in the Table control are not deleted. By default: The existing columns are deleted.
taItemCaption The captions of items are used for the titles of columns. By default: The name of the item is used as column title.
taByLogicalOrder The columns are created according to the logical order of items defined in the data model editor.
For the queries, the logical order and the physical order of items are identical. By default: The physical order of the items in the data file is used.
For the queries, the logical order and the physical order of items are identical.
taFillTable A memory Table control will be filled with the content of the data file (Caution: long operation that can overflow the memory). By default: The memory Table controls are not filled.
taInputAutoId Input allowed in the column associated with the automatic identifier (if it exists and if the Table control is in edit).
taNoAdjust The width of the columns is not adjusted (the records are not read).
taNoMemoText The 'text memo' items are not added into the Table control. By default: The "text memo" items are added into the Table control.
taNoMemoImage The "image memo" items are not added into the Table control. By default: The "image memo" items are added into the Table control.

Remarks

Characteristics of Table control (by default)

The columns of Table control defined in the editor are deleted.
The input modes defined in the editor for the Table control are kept.
A column whose type is identical to the item type is created for each item of the data file.
No column is created for the binary memo items (a column is created for the text memo items or for the image memo items).
The properties of Table control and columns are updated to allow the file browse:

<Nom champ Table>.FichierParcouru = <Nom du fichier de données>

and for each column:

<Nom Colonne>.LiaisonFichier = <Nom de la rubrique associée>
<Nom Colonne>.RubriqueParcourue = <Première clé du fichier de donnée>

Memory Table control

If <Table control> corresponds to a memory Table control, no data is displayed (the Table control is empty) but the Table control and column properties are assigned like in the case of a browsing Table control.

To display data in the Table control, use the TableAdd or BuildBrowsingTable functions with the taFillTable constant.

Remark: The taFillTable constant cannot be used to populate a memory Table control with image memos. To add an image into a memory Table control, the corresponding file must be found in the application library (WDL file) or it must be accessible from the current computer.

Columns

The created columns are named "_COL1", "_COL2", "_COL3", etc. These columns are accessible by programming via the indirection operator { }.

You cannot write:

TABLE_TABLE1._COL1.Largeur = 120 // Génère une erreur "_COL1 inconnu"

You must write:

{"TABLE_TABLE1._COL1"}..Width = 120

Miscellaneous

BuildBrowsingTable performs a browse in the data file. The current record may be modified once this function has been used.
The filling of table by function BuildBrowsingTable is done in a parallel Process in the background: if the data source is a query, this query must not be freed before closing the window or before reinitializing the Table control.

Component: wd270obj.dll

See also

Minimum version required

Version 9

This page is also available for…

Comments

Windev Tutorial Totalizar Coluna BuildBrowsingTable

Videoaula tutorial windev mostrando como totalizar colunas de tabelas criadas com a função BuildBrowsingTable

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

Mister ANDRE MARTINI

21 Jan. 2022

Video BuildBrowsingTable

https://youtu.be/hL-r2hmB4_o

https://windevdesenvolvimento.blogspot.com/2019/02/dicas-2012-windev-tabela-88.html

BuildBrowsingTable(TABLE_AUTOMATICA,"empresa",taWithAutoId+taFillTable)

amarildo

09 Feb. 2019

Exemplo BuildBrowsingTable

//Nessa aula vou mostrar como criar uma tabela com uma coluna
//e com comando BuildBrowsingTable , fazer com
//que ele coloque as colunas corretas e as preenchas

//Qry_Cliente_ler
SELECT
cliente.razao_social_nome AS nome,
cliente.id_cliente AS Id,
cliente.telefone AS telefone
FROM
cliente

//Qry_Material_Ler
SELECT
material.id_empresa_material AS id_material,
material.nome AS nome,
material.preco_venda AS preco_venda
FROM
material

//

BuildBrowsingTable(TABLE_diversos, caixa_conta, ...
taWithAutoId+taFillTable+taInputAutoId+taItemCaption+taByLogicalOrder)
//

BuildBrowsingTable(TABLE_diversos, QRY_cliente_ler,...
taWithAutoId+taFillTable+taInputAutoId+taItemCaption+taByLogicalOrder)

//

BuildBrowsingTable(TABLE_diversos, QRY_material_ler, taWithAutoId+taFillTable+taInputAutoId+taItemCaption+taByLogicalOrder)

// Blog com Video e Exemplo

http://windevdesenvolvimento.blogspot.com.br/2017/02/aula-1064-windev-tabela-044.html

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

De matos

21 Feb. 2017

Usando Querie Com Parâmetro

Você pode usar a função BuildBrowsingTable com querie com ou sem parâmetros: veja o código abaixo:

SWITCH COMBO_tipo_consulta
CASE "Cidades" //querie sem parametro
BuildBrowsingTable(TABLE_consulta,QRY_Cidades,taFillTable)
CASE "Clientes Por Cidade" //querie sem parametro
BuildBrowsingTable(TABLE_consulta,QRY_clientes_por_cidade,taFillTable)
CASE "CRE Por Cliente" //querie com parametro
QRY_cre_do_cliente.CodigoCliente = 2 //parametro CodigoCliente
BuildBrowsingTable(TABLE_consulta,QRY_cre_do_cliente,taFillTable)
END

//Blog
http://is2sisinfo.blogspot.com.br/2016/04/windev-funcao-buildbrowsingtable-com-querie-com-e-sem-parametro.html

ANDRE MARTINI / IS2

22 Apr. 2016

Exemplo Criar Tabela

//Mostrar arquivos
ListDeleteAll(COMBO_arquivos)
s_arquivos_lista is string=HListFile("","")
FOR EACH STRING s_nome_arquivo OF s_arquivos_lista SEPAREE BY CR
IF s_nome_arquivo<>"" THEN
ListAdd(COMBO_arquivos,s_nome_arquivo)
END
END

//Mostra tabela
s_arquivo is string=COMBO_arquivos..StoredValue
BuildBrowsingTable(TABLE_arquivos,s_arquivo,taFillTable)

//Blog com Video e Exemplo
http://windevdesenvolvimento.blogspot.com.br/2016/04/curso-windev-tabela-023.html

De matos AMARILDO

21 Apr. 2016

Last update: 10/20/2021

Send a report | Local help