HToItem (Function)

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

This function is now available for the iPhone/iPad applications.

This function is now available in Universal Windows 10 App mode.

This function is now available in Android Widget mode.

This function is now available for the Android applications.

This function is now available for the Java applications.

New in version 22

This function is now available for the iPhone/iPad applications.

This function is now available in Universal Windows 10 App mode.

This function is now available in Android Widget mode.

This function is now available for the Android applications.

This function is now available for the Java applications.

This function is now available for the iPhone/iPad applications.

This function is now available in Universal Windows 10 App mode.

This function is now available in Android Widget mode.

This function is now available for the Android applications.

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

External language

<Value> must be passed in string format.
A binary memo cannot be assigned by HToItem.

Component : wd240hf.dll