Hi Ariel, > I'm trying to load and download pictures from databases (both embedded > and external data sources like MySQL) using the API with OOoBasic. > > I tested it with an embedded HSQL database. I could load the pictures > through the GUI (it was very easy cause the on line help does not give a > clue!). ... > According to the API reference, once we get the stream it returns an > XinputStrean > ... > The problem is that getBinaryStream return 0, so there is nothing to read.
Hmm. Does it make a difference if you use oInputStream = _ ResultSet.getColumns().getByIndex(2).getBinaryStream(2) instead of? oInputStream = oResultSet.getBinaryStream(2) (This is only wild guessing, but who knows.) In any case, can you provide a small self-contained HSQL database, which allows reproducing this (perhaps best with the macro embedded in a form)? Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]