Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

Duplicate Table Names form Data Dictionary

edited July 2003 in End User
Hi,
I am using a code form Query Wizard and out TMDDTABEL has duplicate table
names i.e we share tables cross the module and some other reasons.
For Data Dictionary in the available Table list it load those duplicate
table names. How can I only load the one table and work on it.
I've duplicate the code from this unit daQueryWizard

procedure BuildAvailableTableList;
var
liIndex: Integer;
liCount: Integer;
lChild: TdaChild;
liItem: Integer;
begin
AvailableList.Items.Clear;
liCount := SQL.AvailableSelectTableCount;
for liIndex := 0 to liCount - 1 do begin
lChild := SQL.AvailableSelectTables[liIndex];
liItem := liIndex;
if AvailableList.Items.IndexOf(TdaTable(lChild).TableAlias) < 0 then
begin // not found than Add so that duplciate won't added
liItem := AvailableList.Items.Add('');
ChildToAvailableItemTables(lChild, liItem);
end;
end;{for}

I know if I skip any items here I will be out of Index?
Any help?

-Bhoj

Comments

This discussion has been closed.