Integer

Description

Converts the value of a string to an integer or obtains an integer value that is stored in a blob.

Syntax

Integer ( stringorblob )

Returns

Integer. Returns the value of stringorblob as an integer if it succeeds and 0 if stringorblob is not a valid number or is an incompatible datatype. If stringorblob is null, Integer returns null.

Usage

To distinguish between a string whose value is the number 0 and a string whose value is not a number, use the IsNumber function before calling the Integer function.

Examples

Example 1

This statement returns the string 24 as an integer:

Integer("24")

Example 2

This statement returns the contents of the SingleLineEdit sle_Age as an integer:

Integer(sle_Age.Text)

Example 3

This statement returns 0:

Integer("3ABC") // 3ABC is not a number.

Example 4

This example checks whether the text of sle_data is a number before converting, which is necessary if the user might legitimately enter 0:

integer li_new_data

IF IsNumber(sle_data.Text) THEN

    li_new_data = Integer(sle_data.Text)

ELSE

    SetNull(li_new_data)

END IF

Example 5

After assigning blob data from the database to lb_blob, this example obtains the integer value stored at position 20 in the blob:

integer i

i = Integer(BlobMid(lb_blob, 20, 2))

See also