[web2py] Re: db manipulation

2012-02-23 Thread Anthony
> > 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 > for

[web2py] Re: db manipulation

2012-02-23 Thread davidjensen
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('in

Re: [web2py] Re: db manipulation

2012-02-22 Thread Anthony
On Wednesday, February 22, 2012 2:39:59 PM UTC-5, nils wrote: > > Hi, > Do you not need to specify a type='string' etc ? Good point. If no type is specified, it defaults to 'string', but assuming the 'date' field is intended to store dates, perhaps he should set the type to 'date'. Anthony

Re: [web2py] Re: db manipulation

2012-02-22 Thread nils
Hi, Do you not need to specify a type='string' etc ? Regards, nils On Wed, Feb 22, 2012 at 7:35 PM, Anthony 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, Febr

[web2py] Re: db manipulation

2012-02-22 Thread Anthony
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 > add