|
- Use conditions
- Equivalence TableSelect
- Value of selected element
- Selection at cell level
TableSelect (Function) In french: TableSelect
// 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 is available from version 18 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 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
|
|
|
|
| |
| |
| |
| |
| |
| |
| | |
| |