Duplicate Table Names form Data Dictionary
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
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
This discussion has been closed.
Comments
dictionary tables, add a filter on the dataset that feeds the data
dictionary component.
Cheers,
Jim Bennett
Digital Metaphors
http://www.digital-metaphors.com
info@digital-metaphors.com