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.
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. |
GetMoreData | Checks if there are more data and gets the next portion. |
Creates a Property object, that describes a user-defined property. | |
Properties | Provides access to the Properties collection. |
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 |