This post on StackOverflow may help 
http://stackoverflow.com/questions/9636053/is-there-a-way-to-get-the-constraints-of-a-table-in-sqlite

There is a code snippet you might try.

On Monday, September 22, 2014 5:01:11 PM UTC-4, Anna Kostikova wrote:
>
> Hi everyone,
>
> I am having an issue when editing content of one of the tables in my 
> database. When I try to edit a record in the table I have an error message 
> "<class 'sqlite3.IntegrityError'> foreign key constraint failed". The 
> bizarre thing is that it doesn't matter which column I am trying to edit 
> (via appadmin control panel) - i have exactly same message. For instance, I 
> have a column "description" that doesn't have any keys on it (or 
> references), but I can't edit the content of this field and I keep getting 
> the error above.
>
> What might be causing the issue?
> I am using python 2.7.7 and web2py 2.9.5
>
> Thanks
> Anna
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to