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