ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / WLanguage properties / Properties associated with windows, pages and controls
  • Value property
  • DataBinding property
  • Table control populated programmatically
  • List Box control populated programmatically
  • Seeking and selecting an element in a List Box or Combo Box control based on a data file
  • Limitations
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
The StoredItem property is used to:
  • Get the stored item or variable of a Table, Looper, List Box or Combo Box control.
  • Change the stored item or variable of a Table, Looper, List Box or Combo Box control.
Remarks:
  • The stored item is used for controls associated with a data file or query. The stored variable is used for controls associated with a variable.
  • The stored item or variable is defined in the window or page editor, in the "Content" tab of the control description.
    StoredItem
Example
// Modify the stored item of the "TABLE_CustomerTable" control
TABLE_CustomerTable.StoredItem = "CustomerName"
Syntax

Getting the stored item or variable of a control Hide the details

<Stored item/variable> = <Control used>.StoredItem
<Stored item/variable>: Character string
  • Name of the stored item for the specified control. This item belongs to the data file the control is based on (returned or modified with the BrowsedFile property).
  • Name of the stored variable for the specified control. This name has the following format ":<prefix><Variable name>" or ":<Variable name>" (the prefix is used only if the code style is enabled in the project).
    This variable belongs to the variable the control is based on (returned or modified with the BrowsedFile property).
  • Empty string ("") if no item or variable is associated with the control.
<Control used>: Control name
Name of control to use:
  • Table control,
  • List Box control,
  • Combo Box control.

Changing the stored item or variable of a control Hide the details

<Control used>.StoredItem = <New item/variable>
<Control used>: Control name
Name of control to use:
  • Table control,
  • List Box control,
  • Combo Box control.
<New item/variable>: Character string
  • Name of the new stored item for the specified control. This item must belong to the data file the control is based on (returned or modified with the BrowsedFile property).
  • Name of the new stored variable for the specified control. 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 (whether or not prefixes are displayed).
    This variable belongs to the variable the control is based on (returned or modified with the BrowsedFile property).
  • Empty string ("") if no item or variable must be associated with the control.
Remarks

Value property

The StoredItem property modifies the value returned by the Value property.
Two distinct cases may occur:
  • The List Box or Table control is manipulated programmatically OR the StoredItem property is set to an empty string (""). The Value property allows you to:
    • Get the selected row. If no row is selected, the Value property returns -1. If you use a multiple-selection List Box or Table control, the number of the last selected row is returned.
    • Select another row by specifying the number of the new row to select. The rows previously selected are deselected.
      To find out the selected row, use one of the following syntaxes:
      ResRow = <List Box or Table control>.Value
      ResRow = <List Box or Table control>
  • The List Box or Table control is based on a data file AND the StoredItem property is not an empty string (""). The Value property is used to identify the stored item for the record associated with the selected row. If no row is selected, the Value property returns an empty string ("").
    To find out the stored item associated with the selected row, the following syntaxes are equivalent:
    ResStoredItem = <List Box or Table control>.Value
    ResStoredItem = <List Box or Table control>.StoredItem

DataBinding property

The StoredItem property is often used in combination with the DataBinding property . This association creates an automatic link between two data files when FileToScreen and ScreenToFile are called.

Table control populated programmatically

If a Table control populated programmatically must display data coming from a data file, a query or a view:
  • Create a Table control populated programmatically in the window editor or in the page editor.
  • In the code, specify the item to loop through with the BrowsedItem property. This item must be in the data file, query or view whose data will be displayed in the Table control populated programmatically.
  • In the code, specify the item to be stored with the StoredItem property. This item must be in the data file, query or view whose data will be displayed in the Table control populated programmatically.
  • Use FileToMemoryTable to initialize the Table control with the desired data. The data will be sorted according to the specified search item.
  • The DisplayedItem property will be automatically initialized.

List Box control populated programmatically

If a List Box or Combo Box control populated programmatically must display data from a data file, query or view:
  • Create a List Box or Combo Box control populated programmatically in the window editor or in the page editor.
  • Use FileToMemoryList to initialize the control with the desired data.
  • The BrowsedFile, DisplayedItem, BrowsedItem and StoredItem properties will be automatically initialized.

Seeking and selecting an element in a List Box or Combo Box control based on a data file

To seek and/or select an element in a List Box or Combo Box control based on a data file, we recommend that you use the following syntax:
LIST_OrderList.StoredItem = "CustomerID"
// Find and select the element whose CustomerID is "135"
LIST_OrderList = 135
// If the element sought is not found, LIST_OrderList will be set to -1

Limitations

The StoredItem property can only be used in the following controls:
  • Table control,
  • List Box control,
  • Combo Box control,
  • WINDEVJava ListView control,
  • WEBDEV - Server code Looper control.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 12/05/2024

Send a report | Local help