PdcDatabase.GetFieldType
Jump to navigation
Jump to search
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)