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.

String. The name of the column.

size%

Integer. The maximum size of data for the field.

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
See Also

FieldInfo method
FieldNativeDataType method

Glossary