> > . > > 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]
