I am trying to replicate the example on loading metadata for all Databases on a server http://www.activedbsoft.com/helpdesk/index.php?pg=kb.page&id=7 but can't find a unit to include TSQLQualifiedNamesList;
Yeah, found that by doing searches on files in source. However, having issues with that in RadStudio 10.
I can't add the compiled package to the libraries path, Add button doesn't engage. Adding to Browsing Path clears the error about finding acAST.pas, but still doesn't recognize the class...
If I explicitly include the project source,
acAST in 'C:\Program Files (x86)\ActiveDBSoft\Active Query Builder\Sources\acAST.pas', in the uses clause of the project
I.e. manually/explicitly recompile, I am told that a unit UNIVERSAL.Scan was compiled with a different version of acAST.pas than what is in the distributed source code.
This is a DevExpress source code installation done yesterday...So that seems weird.
Maybe my brain is failing on something, I've been .Net(ing) for the last few years.
Sorry for this problem. There's a little difference between the .NET and VCL code. Please find the right code sample below.
procedure TForm1.SpeedButton4Click(Sender: TObject);
var qualifiedNamesList: TSQLQualifiedNamesList;
i: integer;
begin
qualifiedNamesList := TSQLQualifiedNamesList.Create(queryBuilder.SQLContext);
try
queryBuilder.GetDatabasesList(qualifiedNamesList);
for i:=0 to qualifiedNamesList.Count - 1 do
begin
queryBuilder.LoadMetadata(qualifiedNamesList[i]);
end;
finally
qualifiedNamesList.Free;
end;
end;
Hello.