On 1/2/2003 4:53 PM, Milan Maksimovic wrote: >>> 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". It is known as DataSet. However, in legacy ADO, there is also "disconnected recordset". ADO.NET does not have recordset any more. -- Cheers, Peter