Determining the Datatype of a field. 1

[domnu]

Does anyone know how to determine what the underlying datatype for an ADO field is? I know I can use AsString, etc. to make it fit my needs, but is there any way to tell how it is stored in the database?

 

[hilfy]

Use the .DataType property of the field -

Case MyADOTable.FieldByName('MyField').DataType of
ftString:  //do something
ftInteger: //do something else
...
end;

The DataType property is the same whether you're using ADO or BDE components and other components that descend from TDataSet.

-D