> > Myself, I'm not a big fan of high-level abstraction from the sql > > being performed, so I wouldn't use the originally posted idea of > > editing a recordset. > > I don't tend to use it either. But some people like to do things that > way and I'd like to make it as easy as possible for them.
We've implemented something very similar in Python. However, it's limited to a single table and all fields are automatically supplied. Therefore we always guarantee that we have the primary key fields available and can use those in the automatically constructed UPDATE clause. (Actually, using rowid would be a lot easier for us - it's always great reading the SQLite mailing list) If people want to do a join or only want to get a few fields then they have to use a Query() method which returns a resultset. Hugh
