PdcDatabase.GetFieldType

Declaration

GetFieldType(strTableName as String,strFieldName as String) as pdcDbFieldType

Description

Return the field type of the given field in the given table.

Notes

The input parameters are:

• strTableName as string, the table name
• strFieldName as string, the field name

Code example

Dim type
type = pdc.DataBase.GetFieldType("TLE_TILE", "TLE_NAME")

The following pdcDbFieldTypes are available:

pdcDbFieldType - Value - Info
pdcDBFTUnknown - 0 - Unknown
pdcDBFTAutoInc - 1 - AutoInc
pdcDBFTInteger - 2 - Integer
pdcDBFTString - 3 - String
pdcDBFTMemo - 4 - Memo
pdcDBFTFloat - 5 - Float
pdcDBFTCurrency - 6 - Currency, not used right now, currency fields are actualy float fields
pdcDBFTDate - 7 - Date
pdcDBFTTimeStamp - 8 - Date/Time
pdcDBFTTime - 9 - Time
pdcDBFTBoolean - 10 - Boolean
pdcDBFTBlob - 11 - Blob

Availability

Available since September 2018 (from version 5.5)