I'm editing my data model in db.py and trying to add a field to a table of
accounts that groups them using a foreign key.
Field('group', 'reference groups', ondelete='CASCADE',
required=True, default=db(db.groups).select().first().id),
causes a ticket that reads: and causes web2py to freeze
(must force quit and reopen); however,
Field('groupd', 'reference groups', ondelete='CASCADE',
required=True, default=db(db.groups).select().first().id),
works fine.
Can someone explain why this is? Also, is there a better/more elegant way
to specify a default for 'reference' types? Basically I want the default to
be the first entry in the 'groups' table (which is a generic 'ungrouped'
group).
Thank you for any help, I'm a web2py noob coming from a PHP/MySQL
background.
--
