PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

  • Using the ..BrowsedFile property
  • Modifying the properties linked to the browse of a control based on a data file
  • Type of browse
  • Handling the controls based on a data file via the properties
  • Limits
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
..BrowsedFile is used to find out and modify the data source used to display the records in the controls based on a data file:
  • the browsing Table or browsing Treeview Table controls,
  • the browsing List Box or ListView controls,
  • the browsing Combo Box controls,
  • the table columns whose type is browsing combo box,
  • the browsing Looper controls,
  • Versions 16 and later
    WINDEV the browsing Organizer controls,
    New in version 16
    WINDEV the browsing Organizer controls,
    WINDEV the browsing Organizer controls,
  • Versions 16 and later
    the browsing Scheduler controls,
    New in version 16
    the browsing Scheduler controls,
    the browsing Scheduler controls,
  • Versions 16 and later
    WINDEV the browsing Treeview controls,
    New in version 16
    WINDEV the browsing Treeview controls,
    WINDEV the browsing Treeview controls,
  • Versions 17 and later
    WINDEV the browsing Organization Chart controls.
    New in version 17
    WINDEV the browsing Organization Chart controls.
    WINDEV the browsing Organization Chart controls.
  • Versions 19 and later
    the internal windows (if the swipe is enabled).
    New in version 19
    the internal windows (if the swipe is enabled).
    the internal windows (if the swipe is enabled).
  • the supercontrols.
This data source can be:
  • a data file or a query. The records displayed come from this data file or from this query.
  • a variable (array, class member, advanced member, ...)
This data source is defined during the control description ("Content" tab).
Versions 18 and later
Universal Windows 10 App This property is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This property is now available in Windows Store apps mode.
Universal Windows 10 App This property is now available in Windows Store apps mode.
Versions 21 and later
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
Example
// Displays all the customers in a Table control
TABLE_Table1..BrowsedFile = "Customers"
// Displays the entire content of the Qry_Customers query in a Table control
TABLE_Table1..BrowsedFile = "Qry_Customers"

// Displays the contacts of the gAContact variable
// gAContact is a gglContact variable
TABLE_Table1..BrowsedFile = ":gAContact"
Syntax

Finding out the data file, the query or the variable used as data source Hide the details

<Browsed element> = <Control name>..BrowsedFile
<Browsed element>: Character string (with quotes)
Name of the element used as data source for the relevant control. This element can correspond to:
  • the name of the data file or query.
  • the name of the variable. This name has the following format ":<prefix><Variable name>" or ":<Variable name>". The prefix is found only if the programming charter is enabled in the project.The prefix is applied only if the code style is enabled in the project.
<Control name>: Character string (with or without quotes)
Name of the control whose data source is requested. The type of this control must be:
  • browsing table, browsing treeview table,
  • browsing list box, browsing listview,
  • browsing combo box,
  • table column whose type is browsing combo box,
  • browsing looper,
  • Versions 16 and later
    WINDEV browsing organizer,
    New in version 16
    WINDEV browsing organizer,
    WINDEV browsing organizer,
  • Versions 16 and later
    browsing scheduler,
    New in version 16
    browsing scheduler,
    browsing scheduler,
  • Versions 16 and later
    WINDEV browsing treeview,
    New in version 16
    WINDEV browsing treeview,
    WINDEV browsing treeview,
  • Versions 17 and later
    WINDEV browsing organization chart.
    New in version 17
    WINDEV browsing organization chart.
    WINDEV browsing organization chart.
  • Versions 19 and later
    internal window.
    New in version 19
    internal window.
    internal window.

Modifying the file, the query or he variable used as data source Hide the details

<Control name>..BrowsedFile = <New data source>
<Control name>: Character string (with or without quotes)
Name of the control whose current data source must be modified. The type of this control must be:
  • browsing table, browsing treeview table,
  • browsing list box, browsing listview,
  • browsing combo box,
  • table column whose type is browsing combo box,
  • browsing looper,
  • Versions 16 and later
    WINDEV browsing organizer,
    New in version 16
    WINDEV browsing organizer,
    WINDEV browsing organizer,
  • Versions 16 and later
    browsing scheduler,
    New in version 16
    browsing scheduler,
    browsing scheduler,
  • Versions 16 and later
    WINDEV browsing treeview,
    New in version 16
    WINDEV browsing treeview,
    WINDEV browsing treeview,
  • Versions 17 and later
    WINDEV browsing organization chart.
    New in version 17
    WINDEV browsing organization chart.
    WINDEV browsing organization chart.
  • Versions 19 and later
    internal window.
    New in version 19
    internal window.
    internal window.
<New data source>: Character string
Name of the element that must be associated with the relevant control:
  • Name of the data file or name of the query.
  • Variable name. This name has the following format ":<prefix><Variable name>" or ":<Variable name>". The prefix must be specified only if the programming charter is enabled in the project (no matter whether prefixes are displayed or not).The prefix must be specified only if the code style is enabled in the project (no matter whether prefixes are displayed or not).
The control will be empty if this parameter does not correspond to a valid name. The browse will be stopped if this parameter corresponds to an empty string.
Remarks

Using the ..BrowsedFile property

..BrowsedFile can be used during a programmed browse or during an automatic browse.
If ..BrowsedFile is used to modify the data source used, the browse is re-initialized. For a Table control, this operating mode is identical to the use of TableDisplay associated with the taStart constant.

Modifying the properties linked to the browse of a control based on a data file

To modify several properties (..BrowsedItem, ..Filter and ..BrowsedFile), we advise you to:
  1. Stop the browse by assigning an empty string ("") to ..BrowsedFile.
  2. Modify the relevant properties.
  3. Restart the browse with ..BrowsedFile.
This method is used to optimize the modifications performed. Indeed, each one of the modifications performed individually restarts the browse. These operations can become quite slow when they are performed on large data files.

Type of browse

  • Automatic browse: WINDEV, WEBDEV and WINDEV Mobile manage the reading of the data file and the display of the data in the control. No specific programming is required.
    If the control can be sorted (table, ...), the sort is performed on the search item defined in the "Content" tab of the element description.
    If a filter is specified ("Filter on the search item" in the "Content" tab of the object description), this filter is used.
  • Programmed browse: The developer must program the reading of the data file and the display of the data in the control.
    A programmed browse gives total control on the order and on the filter used for the records. However, a programmed browse is a lot more complex and slower than an automatic browse.

Handling the controls based on a data file via the properties

  • The records displayed in the browsing controls come from the data file or query specified by ..BrowsedFile.
  • The sort direction is defined by ..BrowsedItem.
  • Depending on the type of control, the records can be filtered by ..Filter or by HFilter.

Limits

..BrowsedFile only applies to the controls found in a window or in a page. This property only applies to the following controls:
  • Browsing Table controls, browsing TreeView Table controls,
  • Browsing List Box, browsing ListView controls,
  • Browsing Combo Box controls,
  • Supercontrols,
  • Table columns (used to modify the data file linked to a Combo Box table column).
  • Browsing Looper controls,
  • Versions 16 and later
    WINDEV Browsing Organizer controls,
    New in version 16
    WINDEV Browsing Organizer controls,
    WINDEV Browsing Organizer controls,
  • Versions 16 and later
    Browsing Scheduler controls,
    New in version 16
    Browsing Scheduler controls,
    Browsing Scheduler controls,
  • Versions 16 and later
    WINDEV Browsing Treeview controls,
    New in version 16
    WINDEV Browsing Treeview controls,
    WINDEV Browsing Treeview controls,
  • Versions 17 and later
    WINDEV Browsing Organization Chart controls.
    New in version 17
    WINDEV Browsing Organization Chart controls.
    WINDEV Browsing Organization Chart controls.
  • Versions 19 and later
    the internal windows (if the swipe is enabled).
    New in version 19
    the internal windows (if the swipe is enabled).
    the internal windows (if the swipe is enabled).
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment