PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

X
Y
  • ..Value property
  • ..FileLink property
  • Memory Table control
  • Memory List Box control
  • Seeking and selecting an element found in a browsing List Box or 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
..StoredItem 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.
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).
Notes:
  • The stored item is used for the controls associated with a data file or with a query. The stored variable is used for the 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 control 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.
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 the Table controls in the Android applications and in the iPhone/iPad applications.
New in version 20
WINDEV MobileAndroidiPhone/iPad This property is now available for the Table controls in the Android applications and in the iPhone/iPad applications.
WINDEV MobileAndroidiPhone/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
// 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 Name>..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 ..BrowsedFile).
  • 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 programming charter is enabled in the project). This variable belongs to the variable browsed by the control (returned or modified by ..BrowsedFile).
  • Empty string ("") if no stored item/variable is associated with the control.
<Control Name>: Character string (with or without quotes)
Name of control (table, list box or combo box) to use.

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

<Control Name>..StoredItem = <New Item/Variable>
<Control Name>: Character string (with or without quotes)
Name of control (table, list box or combo box) to use.
<New Item/Variable>: Character string
  • Name of new stored item for the specified control. This item must belong to the file browsed by the control (returned or modified by ..BrowsedFile).
  • 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 programming charter is enabled in the project (no matter whether prefixes are displayed or not). This variable belongs to the variable browsed by the control (returned or modified by ..BrowsedFile).
  • Empty string ("") if no stored item/variable must be associated with the control.
Remarks

..Value property

..StoredItem modifies the value returned by ..Value.
Two distinct cases may occur.
  • The List Box control (or the Table control) is a memory control OR ..StoredItem corresponds to an empty string (""). ..Value is used to:
    • Find out the selected row. If no row is selected, ..Value 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 find out the selected row, use one of the following syntaxes:
      ResRow = <Name of List Box or Table>..Value
      ResRow = <Name of List Box or Table>
  • The List Box control (or the Table control ) is a browsing control AND ..StoredItem is not an empty string (""). ..Value is used to find out the stored item for the record associated with the selected row. If no row is selected, ..Value returns an empty string ("").
    To find out the stored item associated with the selected row, the following syntaxes are equivalent:
    ResStoredItem = <Name of list box or table>..Value
    ResStoredItem = <Name of list box or table>..StoredItem

..FileLink property

..StoredItem is often used in association with ..FileLink. This association is used to create an automatic link between two files during the call to FileToScreen and ScreenToFile.

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 store with ..StoredItem. 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 control

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

Seeking and selecting an element found in a browsing List Box or Combo Box control

To seek and/or select an element found 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

Limits

..StoredItem only applies to the:
  • Table controls,
  • List Box controls,
  • Combo Box controls,
  • WINDEVWindows MobileJava ListView controls,
  • WEBDEV - Server code Looper controls.
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment