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,