Thanks for your comment, Yarko I had disabled the table references because the anki (non-web2py) database has over 20 tables, including two tables that cross-reference each other. I did not need those references for my purposes, hence the integer fields.
I was able to successfully update the 'fields' table from web2py without any changes to the table definition above, once I finally figured out what I needed to do. The factId field, for example, worked fine, even with the negative values. The anki application continued to work ok after the update, so that was good, too. The only problem I did have was that this did not work (no errors, just no update): but this did: dx(dx.fields.id==otherfield.first()).update(value=db.staging[row.staging.id].English) -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
