http://sourceforge.net/tracker/index.php?func=detail&aid=1105793&group_id=23316&atid=378133 If you have the time/inclination, it would be appreciated if interested parties try this out. It should be possible to unzip the attached jar into the hsqldb-dev/src folder and rebuild. Yes: there are likely some bugs, but not a huge number, I suspect. Current main "limitation" is that result must consist of columns from a single table, with no computed values, and all columns of table's primary key must be present. Also, duplicate columns are not allowed. In the future, some of these restrictions may be lifted, particularly the primary key column requirement, if there exists an alternate key and all of its columns are present in the result. Cheers, Campbell
------------------------------------------------------- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag-&-drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl _______________________________________________ hsqldb-developers mailing list hsqldb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hsqldb-developers