Sorry, I have not read correctly your answer.



Is there no chance to deleting records in my case (interval)



Thanks

---



Hello,

I think not, it will be delete if the second generator >= 30:

AS

declare variable ist integer ;

begin

ist=GEN_ID(TILOG_ALLG_ID_DEL, 1);

//The generator adding up (+1)

if(ist >= 30) then

// if the generator = 30 then begin

begin

ist = gen_id(TILOG_ALLG_ID_DEL, -10);

// set generator - 10

ist = new.id -20;

// take the record-id -20

delete from tilog_allg where id<=:ist;

// delete all records smaller then record-id - 20

end

end

In this case, every 10 records will be delete the oldest 10 records. But it
doesn't works every time!

What can it be?

May be in the before insert trigger do

new.ID = GEN_ID(TILOG_ALLG_ID_DEL, 1);
ist=new.ID - 30;
delete from tilog_allg where id<=:ist;

There may be concurrency problem, but could be solved if you do

delete from tilog_allg where id=:ist; //

You only delete the ID of the current record less 30, then 31 will delete
ID=1, when 32 is inserted will delete 2.

Regards, Jesus

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]