On Friday, May 16, 2014 9:45:00 AM UTC-7, Ramos wrote: > > I use sqlite as db > Yesterday i had to alter a column (apt_medicaval) to remove not null > contraint. > I used sqliteman to do it.The side effect is that it changed also the id. > Stupid software!!! > > I noticed now when i go to sqliteman, the id field is set as follows > [...] >
> the id shoud be set as > > id INTEGER PRIMARY KEY AUTOINCREMENT, > > now i dont know how to revert it > > Any ideas? > > AIUI, the worst case procedure would be to export the table contents, delete the table, and then re-import them. Sqlite does the export as SQL statements, doesn't it? It should be easy to edit the fields. This could be a pain if you have binary blobs in the table. You may also be able to do a CSV export/import through the admin app, if the app can read the table in its current state. /dps -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
