Convert (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

HCreateMoveableReplica

HCreateSubscriberReplica

HDeactivateAutoFilter

HDescribeFullTextIndex

HErrorStatusModification

HFilterIncludedBetween

HMigrateLinkedCompositeKey

HRecreateSubscriberReplica

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

Convert (Function)

In french: Convert

Converts a numeric value into a binary string in order to perform a search on a numeric key.

Versions 18 and later

This function is now available in Windows Store apps mode.

This function is now available for iPhone/iPad applications.

New in version 18

This function is now available in Windows Store apps mode.

This function is now available for iPhone/iPad applications.

This function is now available in Windows Store apps mode.

This function is now available for iPhone/iPad applications.

Versions 21 and later

This function is now available in Apple Watch mode.

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

New in version 21

This function is now available in Apple Watch mode.

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

This function is now available in Apple Watch mode.

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

Remark: From version 19, HFSQL is the new name of HyperFileSQL.

Example

// CompKey is made of PRODREF (text) and QTY (integer)
// EDT_Quantity and EDT_ProductRef are two edit controls
Srch is string
Srch = Complete(EDT_ProductRef, 8) + Convert(EDT_Quantity)
HReadSeek(Orders, CompKey, Srch)

Syntax

<Result> = Convert(<Numeric value>)

<Result>: Character string

Conversion result. This result is the binary string corresponding to the value of numeric variable. This binary string cannot be directly displayed. This binary string is only used to perform searches in the HFSQL data file.

<Numeric value>: Numeric variable

Name of numeric variable to convert

Remarks

The type of conversion depends on the type of variable passed in parameter.
Convert must be used to perform searches on a numeric composite key in an HFSQL data file. For the simple numeric keys, there is no need to convert the numeric value into binary string, the conversion is automatically performed.
Convert cannot be used in external language. You must use HConvertX.
HConvertX and Convert perform the same action. With Convert (unlike HConvertX), there is no need to specify the type of value to convert ; the type is automatically deduced from the type of <Numeric_Value> variable

Component : wd250vm.dll