Can you post the entire field definition for the foreign key field? On Thursday, February 13, 2014 12:39:26 PM UTC-5, Mirek Zvolský wrote: > > 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.
