Hi folks.

I have a simple table of an sqlite db like this:

dbOBJECT.define_table("Users",
    Field("login", "string", length=80, notnull=True, default=None,
unique=True),
    Field("mac1", "string", length=17, notnull=True, default=None,
unique=True),
    Field("mac2", "string", length=17, default=None, unique=True),
    Field("mac3", "string", length=17, default=None, unique=True),
    Field("mac4", "string", length=17, default=None, unique=True))

The mac2, mac3, and mac4 fields are not required, they can be None, but
login and mac1 are required.
I also wanted to make sure that no mac fields are inserted twice, even for
different logins, so I used unique=True on all fields, but they can't be
None anymore that way. What should I do?







Atenciosamente,

Elcimar Leandro -
http://twitter.com/simakwm
http://elcimar.blogspot.com
Portal Net Fácil  - http://www.nfacil.com.br

Reply via email to