MS SQL Server field metadata
Posted: Sat 31 May 2014 17:21
I use the following code to read fields metadata information from MS SQL Server's tables:
With Unidac version 5.2.5 works fine.
But with newer versions (5.3.8 and 5.3.9) i get the error:
Cannot convert type
Windows 8.1
RAD Studio XE4 (Delphi)
SQL Server Information:
Microsoft SQL Server Management Studio 10.50.1600.1
Microsoft Data Access Components (MDAC) 6.3.9600.16384
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.11.9600.16521
Microsoft .NET Framework 2.0.50727.8000
Operating System 6.3.9600
Thank you
Code: Select all
if MetaDedo.Active then MetaDedo.Close;
MetaDedo.Restrictions.Clear;
if TableN<>'' then
MetaDedo.Restrictions.Add('TABLE_NAME='+TableN);
MetaDedo.MetaDataKind:='Columns';
try
MetaDedo.Open;
...
...But with newer versions (5.3.8 and 5.3.9) i get the error:
Cannot convert type
Windows 8.1
RAD Studio XE4 (Delphi)
SQL Server Information:
Microsoft SQL Server Management Studio 10.50.1600.1
Microsoft Data Access Components (MDAC) 6.3.9600.16384
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.11.9600.16521
Microsoft .NET Framework 2.0.50727.8000
Operating System 6.3.9600
Thank you