On Mon, 7 May 2007 11:28:57 -0400, Jonathan Kahn wrote: >Hey all,
> I have tried different things such as reindex and vacuum on my primary key >auto inc field but I cannot reset it so that things start from one. I >deleted everything from my table but it still keeps the amount that was >there beforehand on the auto inc so anything new is appened to that number >so I used to have 7 records when I insert new it starts at 8, how can I >start it back from 1, its beginning to drive me a little crazy. You could try altering values in the sqlite_sequence table in your database. It works for me. Remember to delete all records in the data table to avoid problems with the auto increment column(s). Chris Peachment ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------