Hi, Regarding my request below... Ive searched the documentation on the website and I am still no clearer on how this is achieved....
Any info greatly appreciated, Cheers, Roger " Ticket 636: Retaining autoincrement (Primary key) generated values I need to re-create a table to add a column or remove a column (as there is no alter table) retain the data table has a primary key auto-increment column Then I cannot keep the values. A function to allow: turning off of auto-incremement then I do my insert of old table rows into new table and then turning back on auto-increment with a seed value (starting point) would be the way to go. As it stands I will lose these values otherwise. Any assistance you can give with this problem would be appreciated. [Append remarks] Remarks: SQLite already provides everything the complainant needs. He just needs to read the documentation a little closer or perhaps consult the mailing list for help. " --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
