EDN: ESRI Developer Network
ESRI Field Object.
| Interfaces | Description |
|---|---|
| IClone (esriSystem) | Provides access to members that control cloning of objects. |
| IField | Provides access to members that return information about the field. |
| IField2 | Provides access to members that return information about the field including raster column definition. |
| IFieldEdit | Provides access to members that edit the field properties. |
| IFieldEdit2 | Provides access to members that edit the field properties including raster column definition. |
| IGPDescribe | Geoprocessing Describe Interface. |
| IGPValue | Value Interface. |
| IModelInfo | Provides access to the model name of the field. |
| IPersist | Defines the single method GetClassID, which is designed to supply the CLSID of an object that can be stored persistently in the system. IPersist is the base interface for three other interfaces: IPersistStorage, IPersistStream, and IPersistFile. |
| IPersistStream (esriSystem) | |
| IXMLSerialize (esriSystem) | Provides access to members that XML serialize and deserialize an object to/from XML. |
A Field object represents a column in a table. A field has many properties, the most obvious ones being name and datatype. The esriFieldType enumeration lists the possible datatypes. This table shows the equivalent field data types in the ArcCatalog user interface, ArcObjects™, Visual Basic®, and a selection of DBMSs.
| ArcCatalog | IField::Type (esriFieldType) |
IField::VarType (VBA variable type) |
Access | SQL Server | Oracle |
|---|---|---|---|---|---|
| Short Integer | esriFieldTypeSmallInteger | vbInteger | Number (Integer) |
smallint | NUMBER |
| Long Integer | esriFieldTypeInteger | vbLong | Number (Long Integer) |
int | NUMBER |
| Float | esriFieldTypeSingle | vbSingle | Number (Single) |
float(8), or numeric if precision and scale specified | NUMBER |
| Double | esriFieldTypeDouble | vbDouble | Number (Double) |
float(8), or numeric if precision and scale specified | NUMBER |
| Text | esriFieldTypeString | vbString | Text | varchar | VARCHAR2 |
| Date | esriFieldTypeDate | vbDate | Date/Time | datetime | DATE |
| Object ID | esriFieldTypeOID | vbLong | AutoNumber (Long Integer) |
int | NUMBER(9) |
| Geometry | esriFieldTypeGeometry | vbDataObject | OLE Object | int | NUMBER(9) or SDO_GEOMETRY, depending on configuration |
| Blob | esriFieldTypeBlob | vbObject | OLE Object | image | LONG_RAW or BLOB, depending on configuration |
| GUID | esriFieldTypeGUID | vbString | Numer (Replication ID) |
uniqueidentifier | CHAR |
| Global ID | esriFieldTypeGlobalID | vbString | Numer (Replication ID) |
uniqueidentifier | CHAR |
| Raster | esriFieldTypeRaster | vbDataObject | Number (Long Integer) |
int | NUMBER |
Field objects do not provide access to all INFO-based (Coverages) data types and attributes. If access to INFO specific characteristics is required use the ArcInfoItem object.
Send feedback on this page