Datatype (database columns) 
Purpose 
Returns the column's data type. It contains a constant integer value indicating the data type of the column. 
This attribute is read only at runtime. 
Syntax 
Table.Column (ColumnID).Datatype [Constant] 
 
 
Constant  | 
Possible values:  | 
 
 | 
fcString  | 
character or text data  | 
 
 | 
fcInteger  | 
long integer numeric data  | 
 
 | 
fcLong  | 
long Integer numeric data  | 
 
 | 
fcSingle  | 
double floating point numeric data  | 
 
 | 
fcDouble  | 
double floating point numeric data  | 
 
 | 
fcCurrency  | 
currency data  | 
 
 | 
fcDate  | 
date and time data  | 
 
 | 
fcBinary  | 
binary data  | 
 
  
 |