Kod: Tümünü seç
procedure TTechnical_PO_Tracing_InvoiceNo.Button2Click(Sender: TObject);
var
f:TextFile;
i,i1:integer;
satir,satir2:string;
begin
i:=0;
i1:=0;
satir:='';
satir2:='';
AssignFile(f, 'd:\Deneme1111.txt');
Rewrite(F);
iBQuery3.Close;
IBQuery3.SQL.Clear;
IBQuery3.SQL.Add('select T1.PONUMBER, T1.SUPPLIER, T1.PO_DATE, T1.TOTAL, T1.CURRENCY from Tablo1 T1 inner join Tablo2 T2 on T1.po_pk=T2.PO2_FK where INVOICE_NO is not null and T2.DELIVERY_DATE between '''+cxDateEdit1.Text+''' and '''+cxDateEdit2.Text+'''');
IBQuery3.Open;
IBQuery3.First;
While NOT IBQuery3.Eof do
begin
Satir := '';
For i := 0 to IBQuery3.Fields.Count -1 do
begin
Satir := Satir + IBQuery3.Fields[i].Text + '!';
end;
begin
IBQuery4.Close;
IBQuery4.SQL.Clear;
IBQuery4.SQL.Add('select COSTCENTER,ACCOUNTCODE,DESCRIPTION from TECHNICAL_PO_TBL_2 where INVOICE_NO is not null and Delivery_Date between '''+cxDateEdit1.Text+''' and '''+cxDateEdit2.Text+''' ');
IBQuery4.open;
IBQuery4.First;
While NOT IBQuery4.Eof do
begin
Satir2 := '';
For i1 := 0 to IBQuery4.Fields.Count -1 do
begin
Satir2 := Satir2 + IBQuery4.Fields[i1].Text + '!';
end;
IBQuery4.Next; //Burdaki next düzgün dönmüyor sanırım ve bunu nereye koyacağımı bilemedim.
end
ibquery3.next;//Bu next düzgün dönüyor
end;
WriteLn(f, satir,Satir2);
end;
CloseFile(f);
end;