Migration was not disabled. However, I made a new application duplicating the original db procedures, and I was able to add a field in the field definition in db.py.
The new one: db = DAL('sqlite://storage2.db') from gluon.tools import Auth auth = Auth(db) auth.define_tables() db.define_table('info',Field('a') ,Field('b') ,Field('c',requires=IS_NOT_EMPTY()), Field('d'), Field('e'), Field('f',requires=IS_NOT_EMPTY()) ) It should be made clear in the documentation that some db operations must use web2py DAL concepts. In the original, I added a field once using db.sqlexecute and once in the sqlite3 bash command line and they do not show in sqlform indicating some operations must have a specific format which is not defined in the current documentation. Also, in order to customize sqlform, etc., the underlying definitions should be made clear in the documentation. I have not looked at the source yet, but I anticipate this will be time consuming. There was an initial effort at collaborative documentation. Please resume this. On Feb 22, 11:35 am, Anthony <abasta...@gmail.com> wrote: > Did you turn off migrations via DAL(..., migrate=False) or DAL(..., > migrate_enabled=False)? Is this in a web2py app, or an external script or > shell? > > > > > > > > On Wednesday, February 22, 2012 2:16:17 PM UTC-5, davidjensen wrote: > > > In db.py, I created a db 'contacts' with a table 'mytable'. I later > > added a field 'date' to mytable. > > > db.define_table('mytable', > > Field('date',requires=IS_NOT_EMPTY()), > > Field('name',requires=IS_NOT_EMPTY()), > > Field('organization'), > > Field('notes','text', requires=IS_NOT_EMPTY()) > > ) > > > The new field did not show. Is it necessary to use db.executesql with > > an alter statement or is there a way to do this in web2py? I can also > > use sqlite3 command line. > > > Thanks,