procedure Tfrmdayrepinput.BitBtn1Click(Sender: TObject); begin if table1.Active =false then table1.Active :=true else table1.Active:=true; table1.EmptyTable ; while not query1.Eof do begin table1.open; table1.Insert; table1.Fields[0].AsString:=query1.Fields[0].AsString; // table1.Fields[1].AsString:=query1.Fields[1].AsString; table1.Fields[3].AsString:=query1.Fields[2].AsString; table1.Post; query1.Next; end;
UNION [ALL]
SELECT col_1 [, col_2, ... col_n]FROM query1
procedure Tfrmdayrepinput.BitBtn1Click(Sender: TObject);
begin
if table1.Active =false then table1.Active :=true
else
table1.Active:=true; table1.EmptyTable ; while not query1.Eof do
begin
table1.open;
table1.Insert;
table1.Fields[0].AsString:=query1.Fields[0].AsString;
// table1.Fields[1].AsString:=query1.Fields[1].AsString;
table1.Fields[3].AsString:=query1.Fields[2].AsString;
table1.Post;
query1.Next;
end;