hello i have this table db.define_table('pedidos', Field('amostra',db.amostras), Field('destino'), Field('estante','integer'), Field('x','integer'), Field('y','integer'), Field('estante1',compute =lambda r:"_E_"+str(r['estante'])+str(r['x'])+str(r['y'])), Field('created','datetime',default=request.now), Field('sit',default='danger'), Field('creator',db.auth_user,default=auth.user_id), )
when i do this db.pedidos.update_or_insert((db.pedidos.amostra==amostra.n) & (db.pedidos.destino=='end'),amostra=amostra.n,destino='end',estante=amostra.estante,x=amostra.x,y=amostra.y,creator=6,sit='danger') i get the error <class 'sqlite3.IntegrityError'> foreign key constraint failedVersãoweb2py™Version 2.9.5-stable+timestamp.2014.03.16.02.35.39PythonPython 2.7.9: /usr/local/bin/python (prefix: /usr/local)Traceback 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. Traceback (most recent call last): File "/home/ramstein74/webapps/2py/web2py/gluon/restricted.py", line 220, in restricted exec ccode in environment File "/home/ramstein74/webapps/2py/web2py/applications/lab/controllers/default.py" <https://empre.cires.pt/admin/default/edit/lab/controllers/default.py>, line 510, in <module> File "/home/ramstein74/webapps/2py/web2py/gluon/globals.py", line 385, in <lambda> self._caller = lambda f: f() File "/home/ramstein74/webapps/2py/web2py/applications/lab/controllers/default.py" <https://empre.cires.pt/admin/default/edit/lab/controllers/default.py>, line 62, in deleteAmostrasAntigas db.pedidos.update_or_insert((db.pedidos.amostra==amostra.n) & (db.pedidos.destino=='end'),amostra=amostra.n,destino='end',estante=amostra.estante,x=amostra.x,y=amostra.y,creator=6,sit='danger') File "/home/ramstein74/webapps/2py/web2py/gluon/dal.py", line 9182, in update_or_insert newid = self.insert(**values) File "/home/ramstein74/webapps/2py/web2py/gluon/dal.py", line 9114, in insert ret = self._db._adapter.insert(self, self._listify(fields)) File "/home/ramstein74/webapps/2py/web2py/gluon/dal.py", line 1360, in insert raise e IntegrityError: foreign key constraint failed Help please :) -- 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.