ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • Order of items in the data file
  • 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
Assigns the specified value to an item of the current record.
Remark: This function is rarely used. It is recommended to directly assign the items with the following syntax: <FileName>.<ItemName> = <Value>.
For example: Customer.LastName = "Smith".
Example
// Assigns "Smith" to the second item of the Customer data file
HToItem(Customer, 2, "Smith")
Syntax

Assigning a value to an item (a value for each item of an array item) Hide the details

HToItem(<Data file> , <Item order> [, <Index>] , <Value>)
<Data file>: Character string
Name of the data file used.
<Item order>: Integer
Physical order number of the item in the data file.
<Index>: Optional integer
Index of the array item to assign. If a non-array item is assigned, <Index> must be set to 1.
<Value>: Character string or other
Value that must be assigned to the item. If the value must be assigned to an array item:
  • if <Index> was used, the value will be assigned to the specified indexed item.
  • if none of the previous parameter was used, <Value> must contain all the values of the array item, separated by TAB.
Hyper File 5.5 The array items cannot be assigned.

Assigning a value to an item (a value for an array item) Hide the details

HToItem(<Data file> , <Item order> [, <Array separator>] , <Value>)
<Data file>: Character string
Name of the data file used.
<Item order>: Integer
Physical order number of the item in the data file.
<Array separator>: Optional character string
String used to separated the values of each array item. TAB is used by default.
Hyper File 5.5 The array items cannot be assigned.
<Value>: Character string or other
Value that must be assigned to the item. If the value must be assigned to an array item:
  • if <Array separator> was used, <Value> must contain all the values of the array item, separated by the specified separator
  • if none of the previous parameter was used, <Value> must contain all the values of the array item, separated by TAB.
Hyper File 5.5 The array items cannot be assigned.
Remarks

Order of items in the data file

The order of the items in the data file starts from 1. The order of an item is returned by the Index property.
WINDEVWindowsExternal languageHFSQL ClassicHFSQL Client/ServerStored proceduresHyper File 5.5

External language

  • <Value> must be passed in string format.
  • HToItem does no assign values to binary memo items.
Component: wd290hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help