Andrew Jensen wrote: > 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] >> >> I'd very much like to try it out .( I did try but was not successful ) I was able to have it imported to the macros but was not sure how to use it after that. If you have a step by step complete with database name and table name I'm sure I could pull it off. Sometimes I just don't get things on the first go around but it's my persistence that pays off... Just ask my wife....lol
-- Regards Dave Ashmore SOHO IT Solutions LLC 1934 S. Delaware Dr. Easton, PA 18042 610-258-7128 http://callsohoit.com We now support the Linux Desktop Disclaimer: The below quote is randomly generated and I may or may not agree with the quote. So here is your random bit of wit. ################################################################ (homer) % It could be one of these chemicals here that makes him so smart. Lisa, maybe you should try some of this. -- Homer Simpson Bart The Genius ################################################################ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
