Re: [web2py] Re: Exception not thrown for duplicate values.

2012-05-05 Thread Massimo Di Pierro
You can try simply comment the field out, access appadmin once (will drop the field), and uncomment the field. Otherwise You have to drop the tables and delete the corresponding/*.table files. If you use sqlite you may as well delete everything in databases/*. On Saturday, 5 May 2012 12:44:

Re: [web2py] Re: Exception not thrown for duplicate values.

2012-05-05 Thread RAHUL PRIYADARSI
Mr.Massimo, Thank you for your response.And it is not only the case of unique=true constraing, but also other constraints like is_not_empty. The db is not enforcing these constraints if they are not declared at the first shot. But what shall be done if i wish to enforce theses? shall i drop the tab

[web2py] Re: Exception not thrown for duplicate values.

2012-05-04 Thread Massimo Di Pierro
Validators are not applied to CSV import. The unique=True may be ignored if you are suing sqlite, unless you added it when you first defined the table. If you added unique=True later it is ignored. On Friday, 4 May 2012 22:40:12 UTC-5, rahulserver wrote: > > I am importing data from a csv file a