In my model I defined the following table:
db.define_table('companyactivity',
Field
('company',db.company,default='',notnull=True,ondelete='CASCADE',
writable=False, readable=False),
Field
('activity',db.activity,default='',notnull=True,ondelete='RESTRICT'),
migrate=False)
db.companyactivity.company.requires=[IS_IN_DB(db,db.company.id,'%
(companyname)s'),IS_NOT_IN_DB(db
(db.companyactivity.activity==request.vars.activity),db.companyactivity.activity,error_message='already
in database')]
When I insert records using appadmin, the validator works, I cannot
insert the same combination of company.id and activity.id twice.
However, when I insert records using:
form=crud.create(db.companyactivity)
... the validator doesn't work, I can insert the same combination of
company.id and activity.id more than once.
Did I miss anything in the implementation?
Kind regards,
Annet.
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
