FieldSize Method

See Also

Applies To

OraField

Description

Returns the number of bytes stored in a LONG or LONG RAW field. Not available at design time and read-only at run time.

Usage

data_size = orafield.FieldSize( )

data_size = orafield.DbFieldSize( )

Remarks

Returns the number of bytes stored in a LONG or LONG RAW field, up to a value of around 64KB. If the field contains more than 64KB, FieldSize returns -1 (negative one).

Oracle does not return the length of columns that are greater than 64KB, so the only way to determine the length is to retrieve the column. To conserve resources, columns of length greater than 64KB are not retrieved automatically.

Data Type

Long Integer