FieldSize (ODBCResultSet - LotusScript)

Returns the maximum size of data for a field.

Defined in

ODBCResultSet

Syntax

size% = odbcResultSet . FieldSize( column_id% )

or

size% = odbcResultSet . FieldSize( column_Name$ )

Parameters

column_id%

Integer. The ID of the column. Use any numeric data type, except Currency.

column_Name$

String. The name of the column.

Return value

size%

Integer. The maximum size of data for the field.

Usage

The unit of measurement is usually a byte, but depends on the data source.

The return value may be 0 for some field types that contain large amounts of arbitrary data; for example, rich text fields.

The meaning of size% depends on the field type. For example, the size of a variable-length field is the maximum length of the field, but the stored text can be shorter.

Errors

Invalid column ID or name (DBstsINVC)

Example