MSMetaData component

Guest · Post by **Guest** » Mon 14 Mar 2005 12:53

Is there an example how to use the MSMetadata component, I read the help but I can not figure out how it is supposed to work.

thanks,
Martin

Ikar · Post by **Ikar** » Mon 14 Mar 2005 15:45

We don't have such examples. Using TMSMetadata comes to the next operations:
- Create a components and assign it to TMSConnection
- Set a type for the object for that you would like to get metadata ObjectType
- If it is needed, place limitations using ColumnName, ConstraintName, DatabaseName, SchemaName, TableName
- Set Active := true
- Retrieve requested data as from usual DataSet

Guest · Post by **Guest** » Mon 14 Mar 2005 21:10

Ok, I found that out but using for example otColumns as objecttype and filling in a Tablename gives me all the columns allright but the datatypes (DATA_TYPE) are shown as 131 or 129 (both not in systypes) and the COLUMN_FLAGS are 116 or 100 (meaning what?).

I would like to know the meaning of those fields (for example 131 = VARCHAR) or some hints where to retrieve that info.

regards,
Martn

Ikar · Post by **Ikar** » Tue 15 Mar 2005 10:18

Data is retrieved in original OLE DB representation. For schema types and
decoding methods please refer to MSDN
http://msdn.microsoft.com/library/defau ... owsets.asp