I have similar troubles as here: https://groups.google.com/forum/?fromgroups#!searchin/web2py/smartgrid$20foreign$20key$20constraint$20failed%7Csort:relevance%7Cspell:false/web2py/klspqXpha4E/mCwQ6HC5IhAJ
I just have smartgrid, 1 parent table (main table for smartgrid), 1 child table. At the child foreign key I have standard requires=IS_IN_DB(db, db.parent.id) In parent table I have just first record, child table is completly empty. Now I navigate through the link in smartgrid row (of the single parent record) and try add the first record into child table. This fails with foreign key constraint failed Solution adapter_args=dict(foreign_keys=False) in DAL() works for me. But, can I repair it better? -- 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
