|
- Use conditions
- Equivalence TableSelect
- Value of selected element
- Selection at cell level
TableSelect (Function) In french: TableSelect Returns the subscript of selected element in the Table or TreeView Table control. This subscript can correspond to: - the number of the selected row. The selected row corresponds to the current row on which the selection bar is displayed.
Versions 16 and laterthe number of the selected column if the control allows the selection mode by column. This option can be configured in the "UI" tab of the control description. New in version 16the number of the selected column if the control allows the selection mode by column. This option can be configured in the "UI" tab of the control description. the number of the selected column if the control allows the selection mode by column. This option can be configured in the "UI" tab of the control description. Versions 16 and laterthe number of the selected cell if the controls allows the selection mode by cell. This option can be configured in the "UI" tab of the control description. New in version 16the number of the selected cell if the controls allows the selection mode by cell. This option can be configured in the "UI" tab of the control description. the number of the selected cell if the controls allows the selection mode by cell. This option can be configured in the "UI" tab of the control description. Versions 16 and laterthe column number of the selected cell if the controls allows the selection mode by cell. This option can be configured in the "UI" tab of the control description. New in version 16the column number of the selected cell if the controls allows the selection mode by cell. This option can be configured in the "UI" tab of the control description. the column number of the selected cell if the controls allows the selection mode by cell. This option can be configured in the "UI" tab of the control description.
Versions 20 and later New in version 20
// Subscript of selected row in the "TABLE_Product" control ResSelect = TableSelect(TABLE_Product)
// Rows selected in a multiselection memory Table control FOR i = 1 _TO_ TableSelectCount(TABLE_TABLE1) Trace("Selected element: " + TableSelect(TABLE_TABLE1, i)) END // Equivalent to: // i is int // FOR EACH SELECTED ROW i OF TABLE_TABLE1 // Trace("Selected element: " + TableSelect(TABLE_TABLE1, i-1)) // END
// Delete all selected rows from a Table control // TableDeleteSelect can also be used i is int NbSelection is int NbSelection = TableSelectCount(TABLE_MyTable) FOR i = NbSelection TO 1 STEP -1 TableDelete(TABLE_MyTable, TableSelect(TABLE_MyTable, i)) END
Syntax
<Result> = TableSelect(<Table control> [, <Rank> [, <Information to return>]])
<Result>: Integer - Subscript of selected element in the specified Table control,
- -1 if no element is selected.
<Table control>: Control name Name of control to use. This control can correspond to: - a Table control.
- a TreeView Table control.
If this parameter corresponds to an empty string (""), the control to which the current event belongs is used. <Rank>: Optional integer Rank of selection for a multiselection control. If this parameter is not specified, the subscript of first selected row is returned. For example, to retrieve the first selected element, <Rank> = 1. To retrieve the second selected element, <Rank> = 2, etc. <Information to return>: Optional Integer constant Versions 16 and laterType of information to return: | | tsColumn | <Result> will correspond to the number of the selected column. | tsCellColumn | <Result> will correspond to the column number for the selected cell. | tsRow (Default value) | <Result> will correspond to the number of the selected row. | tsCellLine | <Result> will correspond to the row number for the selected cell. |
If this parameter is not specified, the function will return the number of the selected line. New in version 16Type of information to return: | | tsColumn | <Result> will correspond to the number of the selected column. | tsCellColumn | <Result> will correspond to the column number for the selected cell. | tsRow (Default value) | <Result> will correspond to the number of the selected row. | tsCellLine | <Result> will correspond to the row number for the selected cell. |
If this parameter is not specified, the function will return the number of the selected line. Type of information to return: | | tsColumn | <Result> will correspond to the number of the selected column. | tsCellColumn | <Result> will correspond to the column number for the selected cell. | tsRow (Default value) | <Result> will correspond to the number of the selected row. | tsCellLine | <Result> will correspond to the row number for the selected cell. |
If this parameter is not specified, the function will return the number of the selected line.
Remarks Use conditions TableSelect can be used on: - a browsing or memory control.
- a single-selection or multiselection control. For multiselection Table controls, you must use TableSelect in a loop to get all the selected rows.
Equivalence TableSelect The following syntaxes are equivalent:
Subscript is int Subscript = <Table control>
or
Subscript = TableSelect(<Table control>)
Value of selected element To retrieve the value of selected element, the syntax is:
Subscript is int Subscript = TableSelect(<Table control>) <Element value> = <Table control> [Subscript]
or
<Element value> = <Table control> [<Table control>]
Versions 16 and later New in version 16
This page is also available for…
|
|
|
| |
| //Capturar valores de uma Table com Mutiplas Seleções |
|
| //Capturar valores de uma Table com Mutiplas Seleções Total is int = TableSelectCount(TableGrid_Clientes) x is int Loop(total) x++ trace(TableGrid_Clientes[TableSelect(TableGrid_Clientes, x)]) trace(TableGrid_Clientes[TableSelect(TableGrid_Clientes, x)].COL_Codigo) trace(TableGrid_Clientes[TableSelect(TableGrid_Clientes, x)].COL_Nome) end |
|
|
|
| |
| |
| |
|
| exemplo selecionar linhas tabela |
|
| https://youtu.be/eEu-Iwza-2s
http://windevdesenvolvimento.blogspot.com/2018/06/dicas-1775-publica-windev-23-tabela-80.html
https://groups.google.com/d/forum/amarildowindev
// comandos abaixo
n_QUANTAS_LINHAS_SELECIONADAS is int=TableSelectCount(TABLE_Cliente)
FOR I=1 TO n_QUANTAS_LINHAS_SELECIONADAS // VOU AGORA LER O CADASTRO DE CLIENTE HReadSeekFirst(cliente,clienteid,TABLE_Cliente.COL_Clienteid[TableSelect(TABLE_Cliente,I)]) IF HFound(cliente) THEN // ENTAO AQUI VAMOS FAZER O PROCESSAMENTO // EXEMPLO // APENAS MOSTRAR O NOME Info(cliente.nome) END END
|
|
|
|
| |
| |
| |
|
| Let's do the registry change. |
|
| //Aula 1153 WinDev Curso ErpAmarildo 11 - Tabela Codigo de Alteração
//Nessa aula de hoje //vamos fazer a alteração do registro.
//En esta clase de hoy //Vamos a cambiar el registro.
//In this class today //Let's do the registry change.
IF TableSelect(TABLE_QRY_RELACAO_EMPRESAS)=-1 THEN RETURN _indice is int=TableSelect(TABLE_QRY_RELACAO_EMPRESAS) HReadSeekFirst(empresa,empresaID,TABLE_QRY_RELACAO_EMPRESAS.COL_EmpresaID) IF HFound(empresa) THEN Open(WIN_Form_empresa) END TableDisplay(TABLE_QRY_RELACAO_EMPRESAS,taReExecuteQuery) TableSelectPlus(TABLE_QRY_RELACAO_EMPRESAS,_indice)
|
|
|
|
| |
| |
| |
|
| Tabela - Selecionar varias linhas e ler |
|
| IF YesNo("Tem Certeza que deseja dizer que já levou essa nota") THEN n_quantas_linhas is int=TableSelectCount(TABLE_QRY_ler_manifestacao_mdfe) FOR i=1 TO n_quantas_linhas n_id_man is int=TABLE_QRY_ler_manifestacao_mdfe.COL_01_Id_manifestacao_notas[TableSelect(TABLE_QRY_ler_manifestacao_mdfe,i)] Trace("quantas_linhas:"+n_quantas_linhas+CR+"i:"+i+CR+"n_id_man:"+n_id_man) HReadSeekFirst(nota_fiscal_manifestacao_mdfe,id_manifestacao_notas,n_id_man) IF HFound(nota_fiscal_manifestacao_mdfe) THEN Trace(nota_fiscal_manifestacao_mdfe.id_manifestacao_notas) nota_fiscal_manifestacao_mdfe.xml_baixado=True nota_fiscal_manifestacao_mdfe.nota_transferido=True HModify(nota_fiscal_manifestacao_mdfe) END END atualiza_levar_notas() TraceEnd() END
//Blog com video e exemplo http://windevdesenvolvimento.blogspot.com.br/2016/04/curso-windev-tabela-022-tableselect.html
|
|
|
|
| |
| |
| |
| |
| |
| |
| | |
| |