The easiest way is: db.table.produto_id.requires=IS_NOT_IN_DB(db (db.table.categoria_id==request.vars.categoria_id),'table.produto_id')
Massimo On Sep 30, 11:38 am, Leandro - ProfessionalIT <lsever...@gmail.com> wrote: > Hi, > > I have a table with this fields: > > id > categoria_cliente_id > produto_id > preco > > Well, I need to implement a constraint where the fields > categoria_cliente_id + produto_id are unique. for example: > > id - categoria_cliente_id - produto_id - preco > 01 01 01 12.50 (OK) > 02 02 01 10.00 (OK) > 02 01 01 20.00 (this > violate the constraint, because duplicate the categoria_cliente_id and > produto_id) > > How to implement this constraint in my table definition in db.py ? > > I need create this constraint in my database or the DAL can generate > this to me ? > > -- Leandro. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
