디비에 있는 자료를 트리뷰로 보이기 위한 코드입니다...
근데 second code부분의 코드를 삽입하니 에러가 나요...
좀 가르쳐 주세요...
with qry_tree1 do begin
Close;
Sql.Clear;
Sql.Add(' select distinct Cd_first_name from code_manage');
open;
if recordcount > 0 then begin
first;
Treeview.Items.Clear;
While not EOF do begin
first_cd := FieldByName('Cd_first_name').AsString;
parent1 := Treeview.Items.Add(nil, first_cd);
////////////////////// second code start /////////////////////////////
with qry_tree2 do begin
Close;
Sql.Clear;
Sql.Add(' select distinct Cd_second_name from code_manage');
Sql.Add(' where Cd_first_name = '''+first_cd+''' ');
open;
if recordcount > 0 then begin
first;
Treeview.Items.Clear;
While not EOF do begin
second_cd := FieldByName('Cd_second_name').AsString;
child1 := Treeview.Items.AddChild(parent1, second_cd);
////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////
next;
end;
end;
end;
///////////////////// second code end ///////////////////////////////
next;
end;
end;
end;
> 디비에 있는 자료를 트리뷰로 보이기 위한 코드입니다...
> 근데 second code부분의 코드를 삽입하니 에러가 나요...
> 좀 가르쳐 주세요...
>
> with qry_tree1 do begin
> Close;
> Sql.Clear;
> Sql.Add(' select distinct Cd_first_name from code_manage');
> open;
> if recordcount > 0 then begin
> first;
> Treeview.Items.Clear;
> While not EOF do begin
> first_cd := FieldByName('Cd_first_name').AsString;
> parent1 := Treeview.Items.Add(nil, first_cd);
>
> ////////////////////// second code start /////////////////////////////
> with qry_tree2 do begin
> Close;
> Sql.Clear;
> Sql.Add(' select distinct Cd_second_name from code_manage');
> Sql.Add(' where Cd_first_name = '''+first_cd+''' ');
> open;
> if recordcount > 0 then begin
> first;
> Treeview.Items.Clear;
> While not EOF do begin
> second_cd := FieldByName('Cd_second_name').AsString;
> child1 := Treeview.Items.AddChild(parent1, second_cd);
> ////////////////////////////////////////////////////////////////////////
>
> ////////////////////////////////////////////////////////////////////////
> next;
> end;
> end;
> end;
> ///////////////////// second code end ///////////////////////////////
>
> next;
> end;
> end;
> end;
Child Item의 First 다음에 Treeview.Items.Clear; 가 있어서 TreeView를 계속 Clear
시키고 있군요.