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 ?
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,0.00,0.00,0.00,0.0000,18.0,44.0000,0.00,0.0000,289.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",10.05.2008,3794,"046","TOPTAN SATIS FATURASI**","99","RDEPO","S-0992","360º (10330) SENSÖRMATİK",5.00,20.0000,101.0000,0.00,0.00,0.00,0.0000,18.0,18.0000,0.00,0.0000,120.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",11.06.2008,4056,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","K--301","\NYA 2,5 KABLO",3000.00,0.0000,1020.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,1020.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",11.06.2008,4056,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","K-0001","-NYA 1,5 KABLO",2500.00,0.0000,525.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,525.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",11.06.2008,4056,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","K-0005","-NYA 10 KABLO",300.00,1.0000,405.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,405.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",11.06.2008,4056,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","K-0066","DT 8 DİAFON KABLO",100.00,0.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",11.06.2008,4056,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","K-0346","EKO 12 Lİ W OT.KUTUSU S.A WK 0537,ÇET-SAN",12.00,4.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",11.06.2008,4056,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","K-0617","ÇET-SAN 2 Lİ KRONE MODÜL KUTUSU",1.00,4.0000,4.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,4.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",11.06.2008,4056,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","S-0303","3x10(60)A TRİF. ELEKT. SAYAÇ",1.00,56.0000,56.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,56.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",11.06.2008,4056,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","Z-0205","1x40A B 3kA OTOMAT Vİ-KO",12.00,2.0000,30.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,30.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",03.07.2008,4700,"046","TOPTAN SATIS FATURASI**","99","RDEPO","K-0103","NYA 6 KABLO",300.00,0.0000,213.0000,0.00,0.00,0.00,0.0000,18.0,38.0000,0.00,0.0000,251.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",03.07.2008,4700,"046","TOPTAN SATIS FATURASI**","99","RDEPO","K-0104","NYA 10 KABLO",200.00,1.0000,252.0000,0.00,0.00,0.00,0.0000,18.0,45.0000,0.00,0.0000,297.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",03.07.2008,4700,"046","TOPTAN SATIS FATURASI**","99","RDEPO","K-0148","TTR 2x1,5 KABLO",100.00,0.0000,62.0000,0.00,0.00,0.00,0.0000,18.0,11.0000,0.00,0.0000,73.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",03.07.2008,4700,"046","TOPTAN SATIS FATURASI**","99","RDEPO","S-0302","KÖHLER MONOFAZE DİJ. SAYAÇ",5.00,24.0000,121.0000,0.00,0.00,0.00,0.0000,18.0,21.0000,0.00,0.0000,143.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",03.07.2008,11142,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","I-0006","İZOLE BANT",10.00,0.0000,2.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,2.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",03.07.2008,11142,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","K-0103","NYA 6 KABLO",300.00,0.0000,252.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,252.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",03.07.2008,11142,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","K-0104","NYA 10 KABLO",200.00,1.0000,298.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,298.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",03.07.2008,11142,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","K-0148","TTR 2x1,5 KABLO",100.00,0.0000,73.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,73.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",03.07.2008,11142,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","K-1056","ÇET-SAN 3 NO SIRA KLEMENS",50.00,1.0000,50.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,50.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",03.07.2008,11142,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","S-0302","KÖHLER MONOFAZE DİJ. SAYAÇ",5.00,28.0000,143.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,143.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",14.08.2008,11402,"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",14.08.2008,11402,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","F-0071","EL-Bİ DELTA-GOLYAD ÜÇLÜ TOPR. FİŞ PRİZ",20.00,2.0000,52.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,52.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",14.08.2008,11402,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","I-0006","İZOLE BANT",50.00,0.0000,15.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,15.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",14.08.2008,11402,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","K--337","\TTR 2X1,5 KABLO",100.00,0.0000,67.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,67.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",14.08.2008,11402,"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",14.08.2008,11402,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","K-0152","TTR 3x1,5 KABLO",100.00,0.0000,94.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,94.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",14.08.2008,11402,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","K-0163","RG 6 U4 TV KABLO",100.00,0.0000,35.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,35.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",14.08.2008,11402,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","P-1416","LEYLAK 5 Lİ TOPR. KLE. PRİZ",10.00,3.0000,33.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,33.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",14.08.2008,11402,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","P-1424","LEYLAK 6 LI TOPR. KLEMENSLİ PRİZ",10.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",14.08.2008,11402,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","P-1428","LEYLAK 6 LI ANAH. TOPR. KLE. PRİZ",5.00,6.0000,30.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,30.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",28.08.2008,11492,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","Z-0201","1x16A B 3kA OTOMAT Vİ-KO",24.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",28.08.2008,11492,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","Z-0202","1x20A B 3kA OTOMAT Vİ-KO",24.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",28.08.2008,11511,"009","SATIŞ İADE 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",11.09.2008,6638,"046","TOPTAN SATIS FATURASI**","99","RDEPO","A-0237","SAYPORT 36 W FLORESAN",25.00,1.0000,27.0000,0.00,0.00,0.00,0.0000,18.0,4.0000,0.00,0.0000,32.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",11.09.2008,6638,"046","TOPTAN SATIS FATURASI**","99","RDEPO","R-0132","SAYPORT 2P 40/30 A HK RÖLESİ",5.00,16.0000,81.0000,0.00,0.00,0.00,0.0000,18.0,14.0000,0.00,0.0000,95.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",11.09.2008,6638,"046","TOPTAN SATIS FATURASI**","99","RDEPO","Z-0201","1x16A B 3kA OTOMAT Vİ-KO",60.00,2.0000,121.0000,0.00,0.00,0.00,0.0000,18.0,21.0000,0.00,0.0000,143.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",11.09.2008,6638,"046","TOPTAN SATIS FATURASI**","99","RDEPO","Z-0202","1x20A B 3kA OTOMAT Vİ-KO",60.00,2.0000,121.0000,0.00,0.00,0.00,0.0000,18.0,21.0000,0.00,0.0000,143.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",11.09.2008,11596,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","A-0237","SAYPORT 36 W FLORESAN",25.00,1.0000,32.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,32.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",11.09.2008,11596,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","R-0132","SAYPORT 2P 40/30 A HK RÖLESİ",5.00,19.0000,95.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,95.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",11.09.2008,11596,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","Z-0201","1x16A B 3kA OTOMAT Vİ-KO",60.00,2.0000,142.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,142.0000
"A-015","DETAY ELK.- OKTAY DURGUT- VİZE",11.09.2008,11596,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","Z-0202","1x20A B 3kA OTOMAT Vİ-KO",60.00,2.0000,142.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,142.0000
"A-020","XX",18.09.2008,6841,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","K-1056","ÇET-SAN 3 NO SIRA KLEMENS",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-020","XX",18.09.2008,6841,"002","SATIŞ FATURASI-TOPTAN","03","UĞUR","R-0160","ESEM 2P 40/30 A HK RÖLESİ",12.00,20.0000,249.0000,0.00,0.00,0.00,0.0000,0.00,0.0000,0.00,0.0000,249.0000
ENDTEXT
STRTOFILE(m.lcData,m.lcTemp)
create CURSOR _CRSUNION ;
( ;
CKODU C(16,0) NOT NULL ;
,CADI C(60,0) NOT NULL ;
,TARIH D(8,0) NOT NULL ;
,ISLEMNO I(4,0) NOT NULL ;
,KOD C(3,0) NOT NULL ;
,TANIM C(50,0) NOT NULL ;
,DEPOKODU C(10,0) NOT NULL ;
,DEPOADI C(10,0) NOT NULL ;
,SKODU C(16,0) NOT NULL ;
,SADI C(50,0) NOT NULL ;
,MIKTAR N(10,2) NULL ;
,FIYAT N(10,4) NULL ;
,TUTAR N(15,4) NULL ;
,ISKONTO N(15,2) NULL ;
,ISKONTO2 N(15,2) NULL ;
,ISKONTO3 N(15,2) NULL ;
,ISKTUTAR N(15,4) NULL ;
,KDV N(4,2) NULL ;
,KDVTUT N(15,4) NULL ;
,OTV N(4,2) NULL ;
,OTVTUT N(15,4) NULL ;
,GTOPLAM N(15,4) NULL ;
)
APPEND FROM (m.lcTemp) TYPE delimited
ERASE (m.lcTemp)
endproc
endproc