2017-08-10 18:06 GMT+01:00 António Ramos <ramstei...@gmail.com>: > >> better explanation >> >> first execution >> id=db.entities.update_or_insert( ((db.entities.type==5) & >> (db.entities.entity=="xaaa")),entity="xaaa",type=5) >> >> record inserted >> >> >> id=db.entities.update_or_insert( ((db.entities.type==5) & >> (db.entities.entity=="xaaa")),entity="othertext",type=5) >> >> No record inserted , id=None >> > If id=None, that indicates and update was done rather than an insert.
the tried again > > id=db.entities.update_or_insert( ((db.entities.type==5) & > (db.entities.entity=="xaaa")),entity="othertext",type=5) > and record inserted and not updated.... > Well, assuming the id=None returned from the previous attempt indicated an update, that means there is no longer a record with entity="xaaa", so this third call will now insert a new record with that value, as expected. Anthony -- 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.