query.open; query.first; while not Query1.Eof do begin function1; Query1.Next; end;在function1中执行一个语句存入另外一个表: Query2.SQL.Clear; Query2.SQL.Add('Insert into Lucky_info(Lucky_Num, Tel_Num)'); Query2.SQL.Add('Values(:AA, :BB)'); Query2.ParamByName('AA').AsString := Query.fieldsbyname('tel_num') Query2.ParamByName('BB').AsString := 'tmp'; Query2.ExecSQL;
我知道了: query.open; query.first; while not Query1.Eof do begin function1; //这里应为query.Next,你打错了不是Query1 Query1.Next; end;
query1.insert;
query1['lucky_num]:='AA';
query1['Tel_num']:='BB';
query1.post;
query.first;
while not Query1.Eof do
begin
function1;
Query1.Next;
end;在function1中执行一个语句存入另外一个表:
Query2.SQL.Clear;
Query2.SQL.Add('Insert into Lucky_info(Lucky_Num, Tel_Num)');
Query2.SQL.Add('Values(:AA, :BB)');
Query2.ParamByName('AA').AsString := Query.fieldsbyname('tel_num')
Query2.ParamByName('BB').AsString := 'tmp';
Query2.ExecSQL;
query.open;
query.first;
while not Query1.Eof do
begin
function1;
//这里应为query.Next,你打错了不是Query1
Query1.Next;
end;