|
- 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 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. | | | 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.
  Reminder: Multiselection is not available for Table controls in classic mode.
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
|
|
|
|
| |
| |
| |
| |
| |
| |
| | |
| |