I had a quick look at HSQLDB last night, I had a look at the insertRow stuff, I can see how that could be made to work.
When moveToInsertRow is called, a flag would be set in the resultset, so that any updateXXX() call would populate a 'holding area', maybe a vector that is indexed by column number, or a Hashtable with the column name as the key (this could cause a problem if two columns were called the same thing, i.e. SELECT across multiple tables.).
When the insertRow() function is called, the 'holding area' data would (somehow) be inserted, this is the bit that I don't really understand how do do, would I use an INSERT as normal, or is there some internal method within HSQLDB. I would then have to add the data to the end of the resultset (a requery would be too inefficient, and unpredictable.)
As always, any input is greatly appreciated.
Thanks
Moray
------------------------------------------------------- This SF.net email is sponsored by: SF.net Giveback Program. SourceForge.net hosts over 70,000 Open Source Projects. See the people who have HELPED US provide better services: Click here: http://sourceforge.net/supporters.php _______________________________________________ hsqldb-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
