PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN

This content has been translated automatically. Click here to view the French version.
  • Using the Property BrowsedFile
  • 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
The Property BrowseFile allows to know and modify the HEX@ of data used for the display of records in a data file based fields. :
  • browsing Table or browsing Treeview Table controls,
  • browsing List Box or ListView controls,
  • browsing Combo Box controls,
  • table columns whose type is browsing combo box,
  • 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
    internal windows (if the swipe is enabled).
    New in version 19
    internal windows (if the swipe is enabled).
    internal windows (if the swipe is enabled).
  • 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 15 and later
Android This property is now available for Android applications.
New in version 15
Android This property is now available for Android applications.
Android This property is now available for Android applications.
Versions 17 and later
iPhone/iPad This property is now available for iPhone/iPad applications.
New in version 17
iPhone/iPad This property is now available for iPhone/iPad applications.
iPhone/iPad This property is now available for iPhone/iPad applications.
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 20 and later
WINDEV MobileAndroidiPhone/iPad This property is now available for Table controls and table columns in Android and iPhone/iPad applications.
New in version 20
WINDEV MobileAndroidiPhone/iPad This property is now available for Table controls and table columns in Android and iPhone/iPad applications.
WINDEV MobileAndroidiPhone/iPad This property is now available for Table controls and table columns in Android and iPhone/iPad applications.
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.FileBrowse = "Clients
// Displays the entire content of the Qry_Customers query in a Table control
TABLE_Table1.FileBrowse = "Req_Clients"
 
// Displays the contacts of the gAContact variable
// gAContact is a gglContact variable
TABLE_Table1.FilePlayed = ":gUnContact
Syntax

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

<Browsed element> = <Control used>.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 applied only if the code style is enabled in the project.
<Control used>: Control name
Name of the control whose data source is requested. The type of this control must be:
  • browsing table or treeview table,
  • browsing list box or 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 data file, query or variable used as data source Hide the details

<Control used>.BrowsedFile = <New data source>
<Control used>: Control name
Name of the control whose current data source must be modified. The type of this control must be:
  • browsing table or treeview table,
  • browsing list box or 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 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 Property BrowsedFile

The BrowsedFile property can be used both during a programmed run and during an automatic run.
If the Property BrowsedFile is used to modify the data HEX@ used, the route is reset.. 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 of the properties BrowsedItem, Filter and BrowsedFile, it is advisable to:
  1. Stop the route by assigning an empty string ("") to the Property BrowsedFile.
  2. Modify the relevant properties.
  3. Restart the course with the Property 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 file fields come from of the data file or from the query specified with the BrowsedFileproperty.
  • The sort direction is defined by BrowsedItem.
  • Depending on the type of control, the records can be filtered by Filter or by HFilter.

Limits

The Property BrowsedFile applies only to the fields of a window or 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
    internal windows (if the swipe is enabled).
    New in version 19
    internal windows (if the swipe is enabled).
    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