HToItem (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Order of items in the data file

External language

See also

ExecuteQueryAsynchronous

ExecuteSQLQueryAsynchronous

HCreateMoveableReplica

HCreateSubscriberReplica

HDeactivateAutoFilter

HDescribeFullTextIndex

HErrorStatusModification

HExecuteQuery

HExecuteQueryAsynchronous

HExecuteSQLQuery

HExecuteSQLQueryAsynchronous

HFilterIncludedBetween

HMigrateLinkedCompositeKey

HRecreateSubscriberReplica

Order of items in the data file
External language

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HToItem (Function)

In french: HVersRubrique

Not available with this kind of connection

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". Remark: From version 19, HFSQL is the new name of HyperFileSQL.

Versions 22 and later

This function is now available for 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 Android applications.

This function is now available for Java applications.

New in version 22

This function is now available for 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 Android applications.

This function is now available for Java applications.

This function is now available for 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 Android applications.

This function is now available for Java applications.

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 (with or without quotes)

Name of 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.
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 (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 <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 Index.

External language

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

Component: wd260hf.dll