PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • Characteristics of columns found in a Table control in a page
  • Sortable column (Ajax mode only)
  • Column with search (magnifier): (Ajax mode only)
  • Adjustable column (Ajax mode only)
  • Memory columns and Check Box columns in the browsing Table controls loaded in memory
  • Specific features of the table columns in a page
  • The "List of values" columns
  • Action in the table columns
  • Link column (Table displayed in a page)
  • Creating the Link columns
  • Action
  • Target
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
Overview
The table columns are used to display the information in a Table control. The same type of information is displayed in the same column.
The following types of data can be displayed in a column found in a Table control:
  • Text
  • Currency
  • Time
  • Currency + Euro
  • Check box (Ajax tables only)
  • Numeric/High-precision numeric
  • Date
  • List of values (n AJAX, the list of values are combo boxes)
  • Duration
  • Image (Ajax tables only)
  • Versions 20 and later
    Container
    New in version 20
    Container
    Container
Specific characteristics can be configured for each type of column.
The programming of each type of column corresponds to the programming of the corresponding control.
The following paragraphs present the main characteristics of the columns in a Table control, available in a page regardless of the column type. Some options are available for the Ajax tables only.
See Table columns in a window for more details.
Characteristics of columns found in a Table control in a page
Most characteristics of the columns found in a Table control are configured in the "General" tab of the characteristics of each column.

Sortable column (Ajax mode only)

The user will be able to sort the column via a click performed on its header. This option is available:
  • for all the columns found in a memory Table control.
  • for some columns found in the browsing Table control (only the columns based on key items and not filtered)
and are used to find out the sort direction of the column.
Programming: The sort can also be performed by programming via the following functions:
TableSortAllows you to sort a Table control on one or more columns

Column with search (magnifier): (Ajax mode only)

The user will be able to perform a search in the column of the Table control.
Two methods are available:
  • The user types the sought word directly. This search is automatically performed in the sorted column.
  • A click performed in the header of the column with magnifier is used to display an edit control. The user will only have to type the sought word.
The search is available:
  • for all the columns found in a memory Table control.
  • for the columns of a browsing Table control with automatic browse (only the sortable columns, based on key items, and not filtered).
Caution: The search is not available:
  • for the items associated with a multi-file link.
  • for the Table controls that use a non-proportional scrollbar ("Proportional scrollbar" unchecked in the "Details" tab of the description window of the control).
You have the ability to customize the image used for the magnifier. See Configuring the table columns for more details.
Programming: The search can be performed by programming via the following functions:
TableSeekSeeks a value in a column of a memory, browsing or treeview Table control.
TableSeekChildSeeks a value in a column of a TreeView Table control, in a specified branch.

Adjustable column (Ajax mode only)

The user will be able to resize the columns.
Programming: The columns can be resized by programming with TableAdjust.

Memory columns and Check Box columns in the browsing Table controls loaded in memory

In a browsing Table control loaded in memory, you have the ability to create memory columns: these columns are not linked to a file. These columns can display a calculation for example, ...
The "Check Box" columns in a browsing Table control loaded in memory are specific memory columns. When moving the scrollbar, the boxes that have been checked are automatically kept.
Specific features of the table columns in a page
WEBDEV - Server codeWindows

The "List of values" columns

If a Table control contains a "List of values" column:
  • the content of this list is entered in the column description. The content of this list cannot be modified by programming.
  • by programming, specify the subscript of the list element to use.
Example: The Day column is a "List of values" column. This column contains the following values:
To add a row into the table with the "Afternoon" value in the Day column, you must use the subscript 3:
TableAddLine(TABLE_TableAPT, "John Smith", "London", 3)
WEBDEV - Server codeWindows

Action in the table columns

For all the Table control columns, you can define a specific action that will be performed when the user clicks an element in the column. This action is defined in the "Details" tab of the description window of the column ("Other actions" button).
You can:
  • Perform a preset action.
  • Position on one of the page anchors.
  • Perform an action from a custom link.
For the link columns (with "Submit the value of controls to the server" unchecked), you can also:
  • Display a page of another site.
  • Download, open, display a file.
  • Connect to a file server.
  • Send an email.
Link column (Table displayed in a page)
WEBDEV - Server codeWindows

Creating the Link columns

The Link columns are used to define a Hypertext link when clicking a column. Like for any other link, WEBDEV allows you to define the action and the target associated with the link.
To create a Link column, you must:
  1. Select the column in the Table control.
  2. Select "Link column" in the "Details" tab of the description window of the column.
  3. Specify the action and the target to use ("Details" tab of the description window of the column). See the following paragraphs for more details.
WEBDEV - Server codeWindows

Action

Several preset actions are proposed by default in a drop-down list box. These preset actions depend on the elements found in the page and in the project pages. You can for example choose to display a project page, to run the click code of a button or to point to one of the page anchors.
Caution: The actions are performed after the click code of the Table control.
If no preset action corresponds to the requested action, the "Other actions" button enables you to define a specific action. You can:
  • Perform a preset action.
  • Position on one of the page anchors.
  • Perform an action from a custom link.
For the link columns (with "Submit the value of controls to the server" unchecked), you can also:
  • Display a page of another site.
  • Download, open, display a file.
  • Connect to a file server.
  • Send an email.
WEBDEV - Server codeWindows

Target

If no target is chosen for the action, the action is performed in the default target defined for the current page.
The possible targets of an action are:
New browser (_blank):
Displays the result in a new window of the browser.
Current frame (_self):
Displays the result in the same frame.
Parent frame (_parent):
Displays the result in the source frame (case of nested framesets).
Current browser (_top):
Displays the result in the current page of the browser (without frames).
Other frames of the frameset (if the page belongs to a frameset):
Displays the result in a specific frame.
Minimum required version
  • Version 12
Comments
Click [Add] to post a comment