G'day Ruslan, > You need clone your database. •••• OK. I think it might have been some manipulation of a cursor I was doing after the insert that caused the problem. Reverting to pure SQL has fixed the problem. BTW, I have started using SQL Builder to build complex queries - it's great! Terrific tool - wish I'd looked at it sooner. cheers kim