>> From: "Gavin Sinclair"
>
> > Second, if you want to create utilities for dealing with result sets.
> > For example, in Java you can create (and I have created) an object that
> > buffers a result set and metadata.  If you are clever, you can track
> > changes, deletions, and additions to the data.  If you are really
> > clever, you can use the metadata to construct SQL to change the
> > database to match the buffer.  This allows you to instantiate a result
> > set object by sending it any SQL whatever, change the values in that
> > object, add rows to the object, and delete rows to the object, and then
> > simply call a "commit" method to have the object issue the appropriate
> > update, insert, and delete statements.  >
> > [snip]
>
> This sounds really good.  Has anyone really *really* clever
> generalised all this and released it as a library (in any language)?

Microsoft ADO.NET has something to this, as a so called "disconnected
recordset".


Regards,
M.

PS Maybe you knew this but deliberately wanted to filter out this answer
with a "realy *really* clever" clause? :)