PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

  • Use conditions
  • Displaying a row in first position (syntax 1)
  • Selection bar and TablePosition function
  • Browsing Table control: limitations of TablePosition
  • Entry process of a row
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Displays a Table or TreeView Table control from a specified row or returns the subscript of first row displayed in a Table or TreeView Table control.
Versions 15 and later
PHP This function is now available for the PHP sites.
New in version 15
PHP This function is now available for the PHP sites.
PHP This function is now available for the PHP sites.
Versions 16 and later
Linux This function is now available for the WINDEV applications in Linux.
New in version 16
Linux This function is now available for the WINDEV applications in Linux.
Linux This function is now available for the WINDEV applications in Linux.
Versions 18 and later
WEBDEV - Server codePHP This function can now be used to handle the TreeView Table controls in the WEBDEV and PHP sites.
New in version 18
WEBDEV - Server codePHP This function can now be used to handle the TreeView Table controls in the WEBDEV and PHP sites.
WEBDEV - Server codePHP This function can now be used to handle the TreeView Table controls in the WEBDEV and PHP sites.
Versions 20 and later
Android This function is now available for the Android applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
New in version 20
Android This function is now available for the Android applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Android This function is now available for the Android applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Example
// Subscript of first row displayed in the "TABLE_Product" table
ResPosition = TablePosition(TABLE_Product)
Syntax

Displaying a Table or TreeView Table control from a specified row Hide the details

TablePosition(<Table Control> , <Subscript>)
<Table Control>: Control name
Name of Table or TreeView Table control to use.
If this parameter corresponds to an empty string (""), the table to which the current process belongs will be used.
<Subscript>: Integer
Subscript of row that will be displayed in first position in the table.
The last row is selected by default if this parameter is greater than the number of rows found in the table (returned by TableCount).

Displaying a Table or TreeView Table control from a specified row Hide the details

TablePosition(<Table Control> , <Subscript> [, <Option>])
<Table Control>: Control name
Name of Table or TreeView Table control to use.
If this parameter corresponds to an empty string (""), the table to which the current process belongs will be used.
<Subscript>: Integer
Subscript of row that will be displayed in the Table control. This row is displayed in first position by default.
If <Subscript> is greater than the number of rows found in the table (returned by TableCount), the last row is selected by default.
<Option>: Integer constant
Versions 22 and later
WINDEVWEBDEV - Server codeiPhone/iPadWindows MobilePHP Position of row in the Table control:
taFirst
(Default value)
The row specified by <Subscript> is displayed in first position in the Table control.
Versions 22 and later
taVisible
New in version 22
taVisible
taVisible
The row specified by <Subscript> becomes visible in the Table control. It is displayed:
  • in first position (if <Subscript> is less than the current row).
  • in last position (if <Subscript> is greater than the current row).
If the row is already visible, the display of Table control does not change.
New in version 22
WINDEVWEBDEV - Server codeiPhone/iPadWindows MobilePHP Position of row in the Table control:
taFirst
(Default value)
The row specified by <Subscript> is displayed in first position in the Table control.
Versions 22 and later
taVisible
New in version 22
taVisible
taVisible
The row specified by <Subscript> becomes visible in the Table control. It is displayed:
  • in first position (if <Subscript> is less than the current row).
  • in last position (if <Subscript> is greater than the current row).
If the row is already visible, the display of Table control does not change.
WINDEVWEBDEV - Server codeiPhone/iPadWindows MobilePHP Position of row in the Table control:
taFirst
(Default value)
The row specified by <Subscript> is displayed in first position in the Table control.
Versions 22 and later
taVisible
New in version 22
taVisible
taVisible
The row specified by <Subscript> becomes visible in the Table control. It is displayed:
  • in first position (if <Subscript> is less than the current row).
  • in last position (if <Subscript> is greater than the current row).
If the row is already visible, the display of Table control does not change.

Finding out the subscript of first row displayed in a Table or TreeView Table control Hide the details

<Result> = TablePosition(<Table Control>)
<Result>: Integer
Subscript of first row displayed in the specified control.
PHP Last value of <Subscript> specified in the syntax displaying a row. You cannot find out the first row actually displayed once the table scrollbar has been used .
<Table Control>: Control name
Name of Table or TreeView Table control to use.
If this parameter corresponds to an empty string (""), the Table control to which the current process belongs will be used.
Remarks

Use conditions

TablePosition can be used on:
  • a browsing or memory control,
  • a single-selection or multi-selection control.
WEBDEV - Server codePHP Reminder: The multi-selection controls are available in Ajax only.
WEBDEV - Server codePHP Reminder: The multi-selection is not available for the "standard" Table controls.
AndroidiPhone/iPad The TreeView Table control is not available.

Displaying a row in first position (syntax 1)

The row displayed in first position may differ from the requested one. Indeed, TablePosition tries to display as many rows as possible in the control.
TablePosition will display the specified row only if this row is followed by a sufficient number of non-empty rows. In the following example, the "Durand" row cannot be displayed at the beginning of Table control.

Selection bar and TablePosition function

TablePosition does not modify the current row (which means the row selected via the selection bar).
Therefore, if the Table control has focus when TablePosition is run, the current row will have to be visible at the same time as the specified row. If the current row and the specified row cannot be displayed at the same time, the content of the control will be displayed from the current row (and not from the row specified by <Subscript>).
WINDEVReports and QueriesWindows MobileJavaUser code (UMC)

Browsing Table control: limitations of TablePosition

TablePosition does not operate with the browsing Table controls in "manual" mode that use a scrollbar with an ongoing movement ("Proportional scrollbar" not checked in the "Details" tab of the control description).
Reminder:
  • A browsing Table control in "manual" mode is a control that is linked by programming to a data file.
  • A scrollbar with an ongoing movement allows you to move the scrollbar by keeping the mouse button pressed on the scrollbar box or by keeping one of the arrow keys down.

Entry process of a row

  • TablePosition does not force the execution of the entry process in the control row.
  • TablePosition cannot be used in the entry process of the row (the result is incorrect).
Components
WINDEVReports and Queries wd230obj.dll
WEBDEV - Server code wd230page.dll
Windows Mobile wp230obj.dll
Java wd230java.jar
Linux wd230obj.so
Android wd230android.jar
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment