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]