1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
| procedure TForm1.Timer1Timer(Sender: TObject);
var i:integer;
begin
if not IBTable1.active then exit;
i:=random(range);
with ibdataset1 do begin
Selectsql.clear;
selectsql.Add(format('select * from %s where ENTIER1=%d',[IBTable1.TableName,i]));
Open;
last;
if recordcount>0 then begin
close;
selectsql.clear;
selectsql.Add(format('delete from %s where ENTIER1=%d',[IBTable1.TableName,i]));
open;
close;
inc(DeleteCount);
end
else begin
close;
selectsql.clear;
selectsql.Add(format('insert into %s (ENTIER1, ENTIER2) values (%d,%d)',[IBTable1.TableName,i,random(range)]));
open;
close;
inc(insertcount);
end;
end;
Synchronize;
end; |
Partager