TUniMetaData and Sql Server Datatypes

[martin.trummer]

the TUniMetaData component returns a numeric value for the DATA_TYPE field:
e.g.

Code: Select all

DataType := FUniMetaData.FieldByName('DATA_TYPE').AsString; 
// returns 5 for a float field

how can I get the data-type as string - i.e. 'float' instead of 5?

[martin.trummer]

this seems to be some kind of ole-db data type

instead of TUniMetaData, it's easier for me to use a simple query that returns the native data-types:

Code: Select all

SELECT TABLE_NAME, COLUMN_NAME , ordinal_position as POSITION,
DATA_TYPE ,
numeric_precision as DATA_PRECISION ,
numeric_scale as DATA_SCALE ,
is_nullable as NULLABLE
FROM INFORMATION_SCHEMA . COLUMNS
where table_catalog = 'ds'
and table_schema= 'dbo'
order by TABLE_NAME , ORDINAL_POSITION

[azyk]

At present UniDAC does not support this functionality. You can suggest this feature at our UserVoice http://devart.uservoice.com/forums/1046 ... 939-unidac . If the suggestion gets a lot of votes, we will consider the possibility to implement it.