25-03-2012, 06:14 PM
هذه محاولتي:
لكنها بطيئة جدا
كود :
if check then
begin
MDBGrib.DataSource := nil;
IDList := TStringList.Create;
ADOQuery1.SQL.Text := 'Select ID_J from users';
ADOQuery1.Active := true;
while not DataSource1.DataSet.EOF do
begin
IDList.Add(DataSource1.DataSet.FieldByName('ID_J').AsString);
DataSource1.dataset.next;
end;
for i := 0 to IDList.count-1 do
begin
ADOQuery1.SQL.Text := 'Select ID_J from pays where ID_J = '+IDList.Strings[i];
ADOQuery1.Active := true;
if length(ADOQuery1.Fields[0].AsString)=0 then
begin
ADOQuery1.SQL.Text := 'Insert INTO pays values('+IDList.Strings[i]+',1999,02,02,0)';
ADOQuery1.ExecSQL;
end;
end;
MDBGrib.DataSource := DataSource1;
end;
