PC SOFT

ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
  • Specific items
  • External language
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
Returns the content of an item found in the current record (in the data file, view, query, ...).
Versions 18 and later
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This function is now available in Windows Store apps mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Versions 22 and later
iPhone/iPad This function is now available for iPhone/iPad applications.
Android Widget This function is now available in Android widget mode.
Android This function is now available for Android applications.
WINDEVJava This function is now available for Java applications.
New in version 22
iPhone/iPad This function is now available for iPhone/iPad applications.
Android Widget This function is now available in Android widget mode.
Android This function is now available for Android applications.
WINDEVJava This function is now available for Java applications.
iPhone/iPad This function is now available for iPhone/iPad applications.
Android Widget This function is now available in Android widget mode.
Android This function is now available for Android applications.
WINDEVJava This function is now available for Java applications.
Example
CustomerName is string
// The second item of the "Customer" data file
// corresponds to the name of the customer
CustomerName = HRetrieveItem(Customer, 2)
// Equivalent to:
// CustomerName = Customer.Name
Syntax

Retrieving an item by specifying its index Hide the details

<Result> = HRetrieveItem(<Data file> , <Item order> [, <Index>])
<Result>: Type of item
  • Value of the item,
  • Empty string ("") for items with a NULL value.
For an array, all the array items are returned as character strings. The items are separated by the <Array separator> parameter.
<Data file>: Character string
Name of data file, view or query used.
<Item order>: Integer
Physical order of the item in the data file. The order of the items starts from 1.
Reminder: The order of an item can be obtained using its properties (<Data file>.<Item>Index).
<Index>: Optional integer
Index of the item for an array item.
For the non-array items, the index is optional. If it is specified, it must be set to 1.
For array items, if the index is not specified, all the array elements are returned (separated by TAB characters).

Retrieving an item by specifying the array separator Hide the details

<Result> = HRetrieveItem(<Data file> , <Item order> [, <Array separator>])
<Result>: Type of item
  • Value of the item,
  • Empty string ("") for items with a NULL value.
For an array, all the array items are returned as character strings. The items are separated by the <Array separator> parameter.
<Data file>: Character string
Name of data file, view or query used.
<Item order>: Integer
Physical order of the item in the data file. The order of the items starts from 1.
Reminder: The order of an item can be obtained using its properties (<Data file>.<Item>Index).
<Array separator>: Optional character string
Character string used to separate the values of array items (or sub-items) in <Result>. The default separator is TAB.
Caution: for backward compatibility with Hyper File 5.5, the separators are not indicated when the array items are empty.
Remarks

Specific items

  • The content of Binary Memo items is not retrieved but the item separator is present (to avoid a shift).
  • The content of composite keys is not retrieved but the item separator is present (to avoid a shift).
WINDEVExternal languageHFSQLHFSQL Client/ServerHyper File 5.5OLE DBNative Connectors (Native Accesses)

External language

In external language, the <Result> always corresponds to a character string. The content of a binary memo item cannot be retrieved according to this method in external language.
Component: wd270hf.dll
See also
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment