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]

Reply via email to