I assume you're getting an error message on the form itself, which
indicates the problem is with the default validator, not the notnull
attribute (the latter is set in the database and results in a database
error, which results in web2py returning a 500 server error response if not
otherwise trapped). By default, your reference field gets this validator:
IS_IN_DB(db, 'logr_type.id', db.logr_type._format)
That gives you the dropdown list in the form but also requires that a
selection be made. To enable the dropdown but not require a selection, you
can do:
Field('logr_type', 'reference logr_type', notnull=False, label=T('Logr
Type'),
requires=IS_EMPTY_OR(IS_IN_DB(db, 'logr_type.id', '%(name)s')),
represent=lambda id, r: db.logr_type[id].name)
Note, that code also explicitly sets the "represent" attribute of the
field. The reason is that when you explicitly set the "requires" attribute
of a reference field, the default "represent" attribute is no longer set
automatically.
Anthony
On Saturday, January 26, 2013 7:04:24 AM UTC-5, __pyslan__ wrote:
>
> My models:
>
> LogrType = db.define_table('logr_type',
> Field('name', notnull=False, label=T("Name")),
> format='%(name)s'
> )
>
> Venture = db.define_table('venture',
> Field('venture_type', 'reference venture_type', notnull=True,
> label=T("Type")),
> Field('venture_situation', 'reference venture_situation',
> notnull=True, default=1, label=T("Situation")),
> Field('name', notnull=True, label=T("Name")),
> Field('logr_type', 'reference logr_type', notnull=False, label=T('Logr
> Type')),
> Field('logr', notnull=False, label=T('Logradouro')),
> Field('logr_number', notnull=False, label=T('Number')),
> Field('logr_compl', notnull=False, label=T('Complement')),
> Field('logr_neigh', notnull=False, label=T('Neighborhood')),
> Field('logr_city', notnull=False, label=T('City')),
> Field('logr_state', notnull=False, label=T('State')),
> Field('logr_zip_code', notnull=False, label=T('Zip Code'), default=""),
> format='%(name)s'
> )
>
>
> When I add, or edit a venture, the logr_type is required...and should not
> be..
>
>
> Thanks...
>
> __pyslan__
>
>
--
