On Apr 07, 2007, at 1:04 PM, Ian Piper wrote: > Hi all, > > I am still a bit confused about recordsets. I have this piece of code > which is creating a recordset from a query and then trying to update > one field. The recordset is made up from two tables in the database, > but the field I am trying to update is only in one of the tables. I > thought the code below should work, but it fails silently. When I say > silently, I mean that at each point where I have a msgbox below it > displays with the expected contents and there are no exceptions. But > when I check the "newkey" field it is still empty. > > Is it OK to do an update on a recordset that spans tables? I can't > see why it shouldn't work. Or is there another reason that the update > doesn't take? > > Anyway, thanks for any guidance.
Many databases will not let you update a recordset that has results from more than one table. I suspect that SQLite is one of these _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives: <http://support.realsoftware.com/listarchives/lists.html>
