PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

  • 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/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
HToItem (Function)
In French: HVersRubrique
ODBCNot available with this kind of connection
Assigns the specified value to an item of the current record.
Note: This function is rarely used. We recommend that you directly assign the items with the following syntax: <FileName>.<ItemName> = <Value>.
For example: Customer.Name = "Smith".
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 22 and later
iPhone/iPad This function is now available for the iPhone/iPad applications.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
WINDEVJava This function is now available for the Java applications.
New in version 22
iPhone/iPad This function is now available for the iPhone/iPad applications.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
WINDEVJava This function is now available for the Java applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
WINDEVJava This function is now available for the Java applications.
Example
// Assigns SMITH to the second item of Customer 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(<File Name> , <Item Order> [, <Subscript>] , <Value>)
<File Name>: Character string (with or without quotes)
Name of data file used.
<Item Order>: Integer
Physical order number of the item in the data file.
<Subscript>: Optional integer
Subscript of the array item to assign. If a non-array item is assigned, <Subscript> 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 <Subscript> was used, the value will be assigned to the specified subscripted 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.

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

HToItem(<File Name> , <Item Order> [, <Array Separator>] , <Value>)
<File Name>: Character string (with or without quotes)
Name of data file used.
<Item Order>: Integer
Physical order number of the item in the data file.
<Array Separator>: Optional character string (with quotes)
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 <Subscript> was used, the value will be assigned to the specified subscripted 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 ..Subscript.
WINDEVWindowsExternal languageHFSQLHFSQL Client/ServerStored proceduresHyper File 5.5

External language

  • <Value> must be passed in string format.
  • A binary memo cannot be assigned by HToItem.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Windows Mobile wp230hf.dll
Java wd230java.jar
Linux wd230hf.so
Android wd230android.jar
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment