PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

X
Y
  • Type of browse
  • Handling the controls linked to a data file via properties
  • Modifying the properties linked to the browse of a control
  • Memory table
  • Memory List Box and Combo Box control
  • 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
For the controls, ..BrowsedItem is used to:
  • Find out the item used to automatically browse the controls linked to a data file.
  • Modify the item used to automatically browse the controls linked to a data file. Then, the browse is reinitialized.
WEBDEV - Server code This modification is available for the "Automatic" or "Dynamic" controls only ("Details" tab of control description).
WEBDEV - Server code This modification is available for the "Automatic" or "Dynamic" controls only ("GUI" tab of control description).
For a report on file, ..BrowsedItem allows you to modify the item used to browse the file. In this case, this property can only be used in the opening process of the report.
Note: This item is defined when creating the control or the report. This item can be modified in the "Data" tab of the element description.
Versions 15 and later
Android This property is now available for the Android applications.
New in version 15
Android This property is now available for the Android applications.
Android This property is now available for the Android applications.
Versions 17 and later
iPhone/iPad This property is now available for the iPhone/iPad applications.
New in version 17
iPhone/iPad This property is now available for the iPhone/iPad applications.
iPhone/iPad This property is now available for the iPhone/iPad applications.
Versions 18 and later
Universal Windows 10 App This property is now available in Windows Store Apps mode.
iPhone/iPad This property is now available for the reports in the iPhone/iPad applications.
New in version 18
Universal Windows 10 App This property is now available in Windows Store Apps mode.
iPhone/iPad This property is now available for the reports in the iPhone/iPad applications.
Universal Windows 10 App This property is now available in Windows Store Apps mode.
iPhone/iPad This property is now available for the reports in the iPhone/iPad applications.
Versions 20 and later
AndroidiPhone/iPad This property is now available for the Table controls in the Android applications and in the iPhone/iPad applications.
New in version 20
AndroidiPhone/iPad This property is now available for the Table controls in the Android applications and in the iPhone/iPad applications.
AndroidiPhone/iPad This property is now available for the Table controls in the Android applications and in the 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
// -- Opening code of report
// Change the file browsed
RPT_Report1..SourceName = Customer
// New search item for "Customer" file
RPT_Report1..BrowsedItem = CustomerID
WINDEVWEBDEV - Server codeWindows MobileJavaAjaxUser code (UMC)
// Ascending sort on the names of companies
TABLE_CustomerTable..BrowsedItem = "-Company"
Syntax

Finding out the item used for the automatic browse in a browsing control Hide the details

<Browsed Item> = <Control Name>..BrowsedItem
<Browsed Item>: Character string
Name of item used to automatically browse the specified control. This item belongs to the data file browsed by the control (returned or modified by ..BrowsedFile).
If the "-" sign is found before the item name, the browse is performed in descending order.
<Control Name>: Character string (with or without quotes)
Name of control to use.

Modifying the item used for the automatic browse in a browsing control Hide the details

<Control Name>..BrowsedItem = <New Item>
<Control Name>: Character string (with or without quotes)
Name of control to use.
<New Item>: Character string with quotes
Name of new item that will be used to automatically browse the specified control. This item must belong to the data file browsed by the control (returned or modified by ..BrowsedFile).
If the "-" sign is found before the item name, the browse is performed in descending order.
WINDEVWEBDEV - Server codeReports and QueriesiPhone/iPadWindows MobileUniversal Windows 10 AppPHPAjaxUser code (UMC)

Finding out the item used for the automatic browse of a browsing report Hide the details

<Browsed Item> = <Report Name>..BrowsedItem
<Browsed Item>: Character string
Name of item used to automatically browse the specified report. This item belongs to the data file browsed by the control (returned or modified by ..SourceName).
<Report Name>: Character string (with or without quotes)
Name of report on file to use.
WINDEVWEBDEV - Server codeReports and QueriesiPhone/iPadWindows MobileUniversal Windows 10 AppPHPAjaxUser code (UMC)

Modifying the item used for the automatic browse of a browsing report Hide the details

<Report Name>..BrowsedItem = <New Item>
<Report Name>: Character string (with or without quotes)
Name of report on file to use.
<New Item>: Character string
Name of new item used to automatically browse the specified report. This item belongs to the data file browsed by the control (returned or modified by ..SourceName).
Remarks

Type of browse

  • Automatic browse: The browse of the data file and the display of data in the control are automatically performed. No specific programming is required.
    The sort is performed on the search item defined in the "Content" tab of the object description. If a filter is specified ("Filter on the search item" in the "Content" tab of the object description), this filter is used. No browse process is run for the specified object.
  • Programmed browse: The developer must program the browse of the data file and the display of data in the Table control.
    The "Read the first record", "Read the previous record", "Read the next record" and "Read the last record" processes are run. 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 linked to a data file via properties

  • The records displayed in a control linked to a file come from the data file or from the query specified by ..BrowsedFile.
  • The sort direction is defined by ..BrowsedItem.
  • The records can be filtered by ..Filter or by HFilter.

Modifying the properties linked to the browse of a control

To modify ..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.

Memory table

If a memory Table control must display data coming from a data file, a query or a view:
  • Create a memory Table control in the editor.
  • In your program, specify the item to browse with ..BrowsedItem. This item must belong to the data file, to the query or to the view whose data will be displayed in the memory Table control.
  • Use FileToMemoryTable to initialize the Table control with the requested data. The data will be sorted according to the specified search item.
  • ..DisplayedItem will be automatically initialized.

Memory List Box and Combo Box control

If a memory List Box or Combo Box control must display data coming from a data file, a query or a view:

Limits

..BrowsedItem only applies to:
  • the reports whose data source is a data file.
  • the controls (List Box, Table and Combo Box) of a window.
WINDEVWINDEV MobileJava In the windows, ..BrowsedItem only applies to the:
  • Tables.
  • List boxes (and listviews).
  • Combo boxes.
  • Versions 16 and later
    WINDEV Organizers.
    New in version 16
    WINDEV Organizers.
    WINDEV Organizers.
  • Versions 16 and later
    WINDEV Schedulers.
    New in version 16
    WINDEV Schedulers.
    WINDEV Schedulers.
  • Versions 16 and later
    WINDEV TreeView.
    New in version 16
    WINDEV TreeView.
    WINDEV TreeView.
  • Versions 19 and later
    internal windows (when the swipe is enabled).
    New in version 19
    internal windows (when the swipe is enabled).
    internal windows (when the swipe is enabled).
WEBDEV - Server codePHP In the pages, ..BrowsedItem only applies to the:
  • Tables,
  • Loopers,
  • Versions 16 and later
    Linear loopers,
    New in version 16
    Linear loopers,
    Linear loopers,
  • List boxes,
  • Combo boxes,
  • Schedulers.
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment