- Use conditions
- Positioning on the last row of the Table or TreeView Table control
- Equivalence with the TableSelectPlus function
- Special case: Table control with continous scrollbar
- "Selecting a row" event
- Selection at cell level
- Browsing Table control containing more than 10 000 rows
- Row picker
TableSelectPlus (Function) In french: TableSelectPlus Selects a row in a Table or TreeView Table control. The selected row corresponds to the current row on which the selection bar is displayed.
 Versions 20 and later New in version 20
// Select row #5 in the "TABLE_ProductTable" control
TableSelectPlus(TABLE_ProductTable, 5)
// Select rows # 5 and 7
// in the multiselection Table control "TABLE_ProductTable"
TableSelectPlus(TABLE_ProductTable, 5, 7)
Syntax
TableSelectPlus(<Table control> [, <Subscript 1> [... [, <Subscript N>]]])
<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 process belongs will be used. <Subscript 1>: Optional integer Subscript of the first row to select. If <Subscript 1> and <Subscript N> are not specified, all the rows found in the control are selected. TableSelectPlus has no effect if <Subscript 1> and <Subscript N> correspond to rows that are already selected. The subscript of the selected row is returned by TableSelect. If this parameter corresponds to -1, the "current" row (the one with focus) is selected.
<Subscript N>: Optional integer Subscript of the Nth row to select. If <Subscript 1> and <Subscript N> are not specified, all the rows found in the specified control are selected. TableSelectPlus has no effect if <Subscript 1> and <Subscript N> correspond to rows that are already selected. The subscript of the selected row is returned by TableSelect.
Remarks Use conditions TableSelectPlus can be used on: - a browsing or memory control.
- a single-selection or multiselection control.
Positioning on the last row of the Table or TreeView Table control To position on the last row of a Table or TreeView Table control, use one of the following syntaxes: - TableSelectPlus:
TableSelectPlus(<Table control>, <Table control>..Count)
- Property ..Count:
<Table control> = <Table control>..Count
- TableCount:
<Table control> = TableCount(<Table control>)
Equivalence with the TableSelectPlus function For a single-selection Table or TreeView Table control (without stored item), the two following syntaxes are equivalent:
TableSelectPlus(<Table control>, <Subscript>) <Table control> = <Subscript>
Special case: Table control with continous scrollbar Selecting a non-visible row in the Table control does not give focus to the selected row. Remark: We recommend that you use a Table control with proportional scrollbar. "Selecting a row" event The event "Selecting a row" is not run when TableSelectPlus is called. Versions 16 and later New in version 16 Browsing Table control containing more than 10 000 rows In a browsing Table control containing more than 10 000 rows, for performance reasons, the positioning in the Table control is approximate. For an exact positioning, you must: - Perform a search with HReadSeek.
- Use TableDisplay associated with the taCurrentSelection constant.
Row picker When the style of the Table control contains a row picker, the arrow on the left is positioned on: - the last selected row when the multiple selection is performed with the mouse or with the keyboard,
- the row to which "focus" is gien by assigning the Table control. For example:
// Positions the row picker on the 3rd row
// And selects the rows 3, 4 and 5
TABLE_ListCustomers = 3
TableSelectPlus(TABLE_ListCustomers, 3, 4, 5)
This page is also available for…
|
|
|
| |
| 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) |
|
|
|
| |
| |
| |
|
| Let's change the Add Button Code |
|
|
//Nessa aula de hoje
//Vamos alterar o Codigo do Botao Incluir
//na Relacao de Empresas
//In this class today
//Let's change the Add Button Code
//In the Business Relationship
//En esta clase de hoy
//Cambiar el código del botao Incluir
//En la Relación de Empresas
HReset(empresa)
Open(WIN_Form_empresa)
TableDisplay(TABLE_QRY_RELACAO_EMPRESAS,taReExecuteQuery)
TableSelectPlus(TABLE_QRY_RELACAO_EMPRESAS,TABLE_QRY_RELACAO_EMPRESAS..Occurrence)
//Blog com Video e Exemplo
https://forum.pcsoft.fr/pt-BR/pcsoft.br.windev/2374-video-aulas-amarildo-aula-1150-windev-curso-erpamarildo/read.awp
http://windevdesenvolvimento.blogspot.com.br/2017/05/aula-1150-windev-curso-erpamarildo-8.html
https://www.youtube.com/watch?v=r87vz1ref7k
|
|
|
|
| |
| |
| |
|
| | // Exemplo TableSelectPlus
TableDisplay(TABLE_material_grupo)
TableSelectPlus(TABLE_material_grupo,TABLE_material_grupo..Occurrence)
// Blog com Video e Exemplo
http://windevdesenvolvimento.blogspot.com.br/2016/12/aula-985-tabela-36-tableselectplus.html
https://www.youtube.com/watch?v=WOvzwpfAuB8
|
|
|
|
| |
| |
| |
|
| | //Estou Indo Linha a Linha
//I´m going line by line
//je vais ligne par ligne
gn_contador++
TableSelectPlus(TABLE_Cliente,gn_contador)
//Vou direto para Essa Linha 5
//I go straight to line 5
//je vais directement à la ligne 5
TableSelectPlus(TABLE_Cliente,5)
//Blog com video e Exemplo
http://windevdesenvolvimento.blogspot.com.br/2016/02/curso-windev-tabela-009-tableselectplus.html
|
|
|
|
| |
| |
| |
| |
| |
| |
| | |
|