PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN

  • Value property
  • FileLink property
  • Memory Table control
  • Memory List Box control
  • Seeking and selecting an element in a browsing List Box or Combo Box control
  • Limitations
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
The StoredItem property is used to:
  • Find out the stored item or the stored variable of a Table, Looper, List Box or Combo Box control.
  • Modify the stored item or the stored 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 the stored variable is defined in the window editor or in the page editor, in the "Content" tab of the control description.
    StoredItem
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
// Modify the stored item of the "TABLE_CustomerTable" control
TABLE_CustomerTable.StoredItem = "CustomerName"
Syntax

Finding out the stored item or variable of a control Hide the details

<Stored item/variable> = <Control used>.StoredItem
<Stored item/variable>: Character string
  • Name of stored item for the specified control. This item belongs to the data file browsed by the control (returned or modified by the BrowsedFile property).
  • Name of 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 browsed by the control (returned or modified with the BrowsedFile property).
  • Empty string ("") if no stored item/variable is associated with the control.
<Control used>: Control name
Name of the control to be used:
  • Table control,
  • List Box control,
  • Combo Box control.

Modifying the stored item/variable of a control Hide the details

<Control used>.StoredItem = <New item/variable>
<Control used>: Control name
Name of the control to be used:
  • Table control,
  • List Box control,
  • Combo Box control.
<New item/variable>: Character string
  • Name of new stored item for the specified control. This item must belong to the data file browsed by the control (returned or modified by 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 prefixes are displayed or not).
    This variable belongs to the variable browsed by the control (returned or modified with the BrowsedFile property).
  • Empty string ("") if no stored item/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 a memory control OR the StoredItem property corresponds to an empty string (""). The Value property is used to:
    • Find out the selected row. If no row is selected, the Value property returns -1. If the List Box control (or the Table control) is multi-selection, the number of the last selected row is returned.
    • Move the selection by specifying the number of the new row to select. The rows that were selected beforehand are deselected.
      To identify the selected row, use one of the following syntaxes:
      ResRow = <Name of the List Box or or Table control>.Value
      ResRow = <Name of the List Box or or Table control>
  • The List Box or Table control is a browsing control 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 = <Name of the List Box or Table control>.Value
    ResStoredItem = <Name of the List Box or Table control>.StoredItem

FileLink 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.

Memory Table control

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 window editor or in the page editor.
  • In your program, specify the item that will be browsed by 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.
  • In your program, specify the item to be stored with the StoredItem property. 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 desired data. The data will be sorted according to the specified search item.
  • The DisplayedItem property will be automatically initialized.

Memory List Box control

If a memory List Box or Combo Box control must display data coming from a data file, a query or a view:
  • Create a memory List Box or Combo Box control 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 browsing List Box or Combo Box control

To seek and/or select an element in a browsing List Box or Combo Box control, 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 applies only to:
  • Table controls,
  • List Box controls,
  • Combo Box controls,
  • WINDEVJava ListView controls,
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment