1

Konu: Sorgu sonucunu treeview ta gosterme

asagida final sorgusu olan cursorume ait data ornegi var bunu treeview olarak gostermek istiyorum,
+ ckodu-cadi
   + kod
         - detaylar
+ ckodu-cadi
   + kod
         - detaylar

seklinde olacak + tiklayinca alt satirda o koda ait cursor satirlari olacak
PS : ikinci asama olarak kod alanina ait gruplamada yapilabilir se daha detayli olur

boyle bir seyi nasil yapabilirim ?

Visual Fox Pro
CreateCursor__CRSUNION()

 
 
Procedure CreateCursor__CRSUNION
LOCAL lcData, lcTemp
lcTemp = SYS(2015)+'.tmp'
TEXT TO m.lcData noshow
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",01.01.2008,1,"114","AÇILIŞ FİŞİ (BORÇ)","","","","",0.00,0.0000,2723.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,0.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",10.01.2008,10055,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","K-0152","TTR 3x1,5 KABLO",100.00,0.0000,93.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,93.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",10.01.2008,10055,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","S-0302","KÖHLER MONOFAZE DİJ. SAYAÇ",10.00,28.0000,289.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,289.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",18.01.2008,312,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","D-0035","NA-DE DAİRE DİAFON ŞUBESİ 050010",8.00,8.0000,66.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,66.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",18.01.2008,312,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","D-0036","NA-DE KAPICISIZ DİAFON SANTRALİ 050020",1.00,48.0000,48.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,48.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",18.01.2008,312,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","K-0052","-NYY 3x35/16 KABLO",40.00,17.0000,691.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,691.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",18.01.2008,312,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","P-0219","NA-DE 8 Lİ FOTOSELLİ HOP. ZİL PANOSU",1.00,40.0000,40.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,40.0000
"A-020","XX",14.02.2008,10248,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","K-0069","2x0,75 YASSI KORDON KABLO",200.00,0.0000,40.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,40.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",28.02.2008,10322,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","D-0205","TİJ DUY",100.00,0.0000,36.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,36.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",28.02.2008,10322,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","O-0083","SİEMENS 1P B 10A W OTOMAT",12.00,3.0000,39.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,39.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",28.02.2008,10322,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","O-0084","SİEMENS 1P B 16A W OTOMAT",12.00,3.0000,39.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,39.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",28.02.2008,10322,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","R-0132","SAYPORT 2P 40/30 A HK RÖLESİ",8.00,16.0000,133.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,133.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",28.02.2008,10322,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","S-0992","360º (10330) SENSÖRMATİK",10.00,24.0000,240.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,240.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",13.03.2008,10400,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","F-0015","Vİ-KO TOPRAKLI ERKEK FİŞ",50.00,1.0000,53.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,53.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",13.03.2008,10400,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","P-1400","LEYLAK 3 LÜ TOPR. KLEMENSLİ PRİZ",25.00,2.0000,57.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,57.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",19.04.2008,10644,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","K-0138","NYY 3x50/25 KABLO",30.00,26.0000,799.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,799.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",19.04.2008,10644,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","L-0100","GALVANİZ LEVHASI",1.00,29.0000,29.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,29.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",24.04.2008,10683,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","K-0152","TTR 3x1,5 KABLO",100.00,1.0000,103.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,103.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",24.04.2008,10683,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","P-0258","ÇP 416 PANO",1.00,352.0000,352.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,352.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",10.05.2008,3794,"046","TOPTAN SATIS FATURASI**","99","RDEPO","F-0015","Vİ-KO TOPRAKLI ERKEK FİŞ",50.00,0.0000,45.0000,0.00,0.00,0.00,0.0000,18.0,8.0000,0.00,0.0000,53.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",10.05.2008,3794,"046","TOPTAN SATIS FATURASI**","99","RDEPO","K-0069","2x0,75 YASSI KORDON KABLO",200.00,0.0000,36.0000,0.00,0.00,0.00,0.0000,18.0,6.0000,0.00,0.0000,42.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",10.05.2008,3794,"046","TOPTAN SATIS FATURASI**","99","RDEPO","K-0138","NYY 3x50/25 KABLO",20.00,23.0000,468.0000,0.00,0.00,0.00,0.0000,18.0,84.0000,0.00,0.0000,552.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",10.05.2008,3794,"046","TOPTAN SATIS FATURASI**","99","RDEPO","K-0152","TTR 3x1,5 KABLO",200.00,0.0000,170.0000,0.00,0.00,0.00,0.0000,18.0,30.0000,0.00,0.0000,200.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",10.05.2008,3794,"046","TOPTAN SATIS FATURASI**","99","RDEPO","P-1400","LEYLAK 3 LÜ TOPR. KLEMENSLİ PRİZ",25.00,1.0000,49.0000,0.00,0.00,0.00,0.0000,18.0,8.0000,0.00,0.0000,58.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",10.05.2008,3794,"046","TOPTAN SATIS FATURASI**","99","RDEPO","R-0132","SAYPORT 2P 40/30 A HK RÖLESİ",8.00,14.0000,113.0000,0.00,0.00,0.00,0.0000,18.0,20.0000,0.00,0.0000,134.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",10.05.2008,3794,"046","TOPTAN SATIS FATURASI**","99","RDEPO","S-0302","KÖHLER MONOFAZE DİJ. SAYAÇ",10.00,24.0000,245.0000