[web2py] Re: sqlite and 'unique'

2010-04-15 Thread mdipierro
Is it possible you did not have unique=True when you created the table and added that later? sqlite does not support alter table with changing of column attributes. On Apr 15, 3:41 pm, Keith Edmunds k...@midnighthax.com wrote: On Thu, 15 Apr 2010 15:25:56 -0500, thade...@thadeusb.com said:

Re: [web2py] Re: sqlite and 'unique'

2010-04-15 Thread Keith Edmunds
On Thu, 15 Apr 2010 13:56:19 -0700 (PDT), mdipie...@cs.depaul.edu said: Is it possible you did not have unique=True when you created the table and added that later? Yes, that is the case - thanks for clearing that up, much appreciated. Keith -- To unsubscribe, reply using remove me as the

[web2py] Re: sqlite and 'unique'

2010-04-15 Thread mdipierro
Try on a fresh database it should work. On Apr 15, 4:01 pm, Keith Edmunds k...@midnighthax.com wrote: On Thu, 15 Apr 2010 13:56:19 -0700 (PDT), mdipie...@cs.depaul.edu said: Is it possible you did not have unique=True when you created the table and added that later? Yes, that is the case

Re: [web2py] Re: sqlite and 'unique'

2010-04-15 Thread Keith Edmunds
On Thu, 15 Apr 2010 15:06:57 -0700 (PDT), mdipie...@cs.depaul.edu said: Try on a fresh database it should work. I have, it did, thank you again. Perhaps a note in the V3 book about this? Keith -- Subscription settings: http://groups.google.com/group/web2py/subscribe?hl=en