>
> .
>
>

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]