sql := 'select * from db order by id asc' query1.close; query1.open(sql);
while not query1.Eof do begin data1 := query1.FieldByName('data1').AsString; sql := 'select xxx from db where xxxxxx' query2.close; query2.open(sql); if query2.RecordCount > xxx then begin while not query2.Eof do begin xxx := query2.FieldByName('xx').AsString; xxx := query2.FieldByName('xx').AsString; .. .. end; end;
sql := 'select xxxxxx from db where xxxxxxxxx' query2.close; query2.open(sql); if query2.RecordCount > xxx then begin while not query2.Eof do begin xxx := query2.FieldByName('xx').AsString; xxx := query2.FieldByName('xx').AsString; .. .. end; end;
sql := 'select * from db order by id asc' query1.close; query1.open(sql); query1.FetchAll; FDMemTable1.close; FDMemTable1.data := query1.data;
while not query1.Eof do begin data1 := query1.FieldByName('data1').AsString; FDMemTable1.Filtered := False; FDMemTable1.Filter := 'xxxxx'; FDMemTable1.Filtered := True; if FDMemTable1.RecordCount > xxx then begin for I := 1 to 20 do begin xxx := FDMemTable1.FieldByName('xx').AsString; xxx := FDMemTable1.FieldByName('xx').AsString; .. .. end; end;
FDMemTable1.Filtered := False; FDMemTable1.Filter := 'xxxxx'; FDMemTable1.Filtered := True; if FDMemTable1.RecordCount > xxx then begin for I := 1 to 20 do begin xxx := FDMemTable1.FieldByName('xx').AsString; xxx := FDMemTable1.FieldByName('xx').AsString; .. .. end; end;