Field Object

Describes a data field. An instance of this object can be retrieved by using the CreateField method of the Index, TableDef and Relation objects or from the Fields collection.

Properties

Name The name of the object for indentification in the collection.
Type The field type.
Size The field size.
Scale The number of digits after the decimal point.
ForeignName The name of the field, connected with the given relation.
Required A flag, specifying whether this field is required.
SourceTable The name of the table in the database, containing this field.
SourceField The name of the field in the database.
AsString Represents the contents of the field as a string.
AsLong Represents the contents of the field as an integer number.
AsDouble Represents the contents of the field as an real number.
AsBoolean Represents the contents of the field as a boolean value.

Methods

GetMoreData Checks if there are more data and gets the next portion.

CreateProperty

Creates a Property object, that describes a user-defined property.
Properties Provides access to the Properties collection.

Remarks

The ForeignName property is used for creating relations between tables. It refers to the field, on which the external key of the related table will be based.

The Required flag is used for creating tables for determining required fields.

The SourceTable and SourceField properties have the Read-Only attribute.

 

See Also

Fields Object, Index Object, Property Object, Properties Object, Relation Object, TableDef Object, CreateField Method