"Octavian Rasnita" schreef: > but the problem is that the primary key field which has autoincrement > option skips the ID of each record which is not inserted because it > is already in the database, and I don't want that.
This skip is normal in a multi-connection environment. You allocate the next value, and there is just no safe and easy way to unallocate it. Maybe SQLite has a single-connection mode that behaves differently, but I don't think so. So just do a SELECT yourself, before INSERTing. Preferrably in a batch. -- Affijn, Ruud "Gewoon is een tijger." -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] http://learn.perl.org/
