I think sqlite may not enforce this. You can achieve this with validators but I think I can make it easier with an upgrade I am working on... tomorrow.
On Jan 9, 5:30 pm, Jeff Bauer <[email protected]> wrote: > I'm trying to enforce a one-to-one relationship between > tables socdiag and socform with unique: > > db.define_table('socdiag', > Field('socform', db.socform, unique=True), > > However the socdiag table permits multiple values of the > same socform's id to occur in the socform column. I'm using > sqlite. > > Jeff Bauer > Rubicon, Inc.
-- 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.
