Hello Frank, et al, Thanks for the feed back, with yours I now have a total of...1..LOL
Your timing however was perfect. In keeping with the XP paradigm today was spent refactoring - getting rid of globals, some new controls blocks, better error traps, literals to constants, etc - in short turning that jumble into production quality code - if one can call a script such a thing. Using the connection instead of the datasource for the table and query information worked out quite well - thanks. Anyway, next sprint will be this weekend to add query support and one more feature. Column names as first row in export file, as an option. My value added feature to the SELECT INTO functionality delivered by HSQLDB. I'll let folks know when this has been uploaded. On 9/13/06, Frank Schönheit - Sun Microsystems Germany < [EMAIL PROTECTED]> wrote:
Hi Andrew, > I have uploaded the latest copy of the utility and you can (should) download > it at > http://www.paintedfrogceramics.com/OpenOffice/BaseExport/BaseExport.uno.pkg < http://www.paintedfrogceramics.com/OpenOffice/BaseExport/BaseExport.2.uno.pkg > > ... > Anyway, I think that is about it for now. Give it a try if you would. Quite cool. For completeness, I suggest not using the ds.Tables object, since this are table UI information. It might happen that this contains more tables than actually are present in the DB. Use the connection's Tables object instead, as this reflects the actual tables. > The interface dialog has been changed to allow you to choose UTF-8 or ASCII > as the character encoding for the text file. If you uncheck the 'use > default' check box the default encoding will be UTF-8. The HSQLDB docs state > that other encoding besides ASCII and UTF-8 are supported, but the utility > is only supporting these two for now. Would be diffifult to find other ones which are supported, since this depends on the JVM in which HSQL is running. See http://java.sun.com/j2se/1.4.2/docs/api/java/nio/charset/Charset.html for details. > Even if yo select "quote all" on the Field Settings page BLOB fields will be > exported without quotes. This seems to be a 'feature' of HSQLDB, one I did > not know. Interesting to know, thanks for the hint :) Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
