TUniMeta MetaDataKind dont support DataType!

TinTin · Post by **TinTin** » Wed 25 May 2011 01:54

I use sql server/oracle/firebird,I offten convert tablen structs with different database.
So I think If TUniMeta MetaDataKind support DataType Names(Only DataType ID is very trouble!) ,I will Create Table SQL and convert table structs very easy!

TinTin · Post by **TinTin** » Wed 25 May 2011 03:52

Constraints of MetaDataKind can not support foreign key detail infomation.

such as foreign key SQL:

ALTER TABLE ORDERFORM ADD FOREIGN KEY (WAREHOUSEID) REFERENCES WAREHOUSE (WAREHOUSEID) ON DELETE SET NULL ON UPDATE CASCADE;

TUniMeta dont support REFERENCES TableName and FieldName and CASCADE!

I think you can expand Constraints of MetaDataKind,Add New Field Name :
REFERENCES_TABLENAME And REFERENCES_Columns and CASCADE, Dont Use new MetaDataKind !

AndreyZ · Post by **AndreyZ** » Wed 25 May 2011 11:24

Hello,

Please specify why you need data type names and how you want to use them. Data type names are different in different database servers.
We will investigate the possibility of extending information about constraints that is returned by TUniMetaData.

TinTin · Post by **TinTin** » Thu 26 May 2011 08:12

I use data type names to Create Table SQL,Such as Convert MSSQL Table Structs TO Firebird .Maybe some DataBase Get data type names is very difficult! But it is not necessary! you can add data type Names in MetaDataKind=column if it is possible to realize!

AndreyZ · Post by **AndreyZ** » Thu 26 May 2011 11:42

We will add this functionality in one of the next UniDAC builds.