Pic in a blob

[Keith Clark-2]

How do I store a picture, say a jpeg file, into a blob field?

Keith



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[drewjensen]

Keith Clark wrote:
> How do I store a picture, say a jpeg file, into a blob field?
>
> Keith
>
>  

Interactivly:

Add an image control to a form.
View>ToolBars> Form Control
Clisk on the 'More Controls' button on that toolbar and you find the
'Image control' on the "More Controls" toolbar that opens.

Attach it to your blob field.

When the form is in data input mode right click on the control and a
context menu lets you open the Open File Dialog allowing you to select
the grahpic file. Save the record.

Via code:
I put up a basic example not long ago.. search for updateBinaryStream in
the archives or google, there are a good many examples I think.
Otherwise I'll touch that with you again tomorrow also.

Drew


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Alex Thurgood]

Hi Drew, Keith,

> When the form is in data input mode right click on the control and a
> context menu lets you open the Open File Dialog allowing you to select
>
> the grahpic file. Save the record.
>

Bear in mind that you have to keep the mouse button pressed down. If you just right mouse button click, I've found that the context menu only appears briefly before disappearing. I have to keep the button pressed down and move the mouse cursor onto the menu entry in order for the dialog to be opened. Not a huge nuisance for someone used to working with interfaces, but a PITA for non-tech savvy users who complain :-)))

Have any of you noticed that the binary data isn't available in the table representation of the data once images are stored in that field ? This is what I've noticed with the JDBC connector and was wondering whether it is a connector problem because with the MySQL query browser, you get the option to view the data as both binary data and the actual image representation. In the OOo table view, I have just a load of blank fields. One would expect at least the binary data representation. This used to be the case for memo fields in earlier versions of OOo, haven't checked recently whether that's still the case.

Alex

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Frank Schoenheit, Sun Microsystems Germany]

Hi Alex,

> Bear in mind that you have to keep the mouse button pressed down. If
> you just right mouse button click, I've found that the context menu
> only appears briefly before disappearing.

Uhm, indeed, it disappears immediately after releasing the mouse. I
wouldn't say this is expected behavior ... Do we already have an issue
for this?

Ciao
Frank

--
- Frank Schönheit, Software Engineer         frank.schoenheit@... -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Base                       http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Alex Thurgood]

Hi Frank,

I haven't opened one, or even searched on IT for one, so don't know, I just lived with it and explained to my users  ;-) That's not to say I wouldn't like it fixed though :-))

Alex


----- "Frank Schönheit - Sun Microsystems Germany" <Frank.Schoenheit@...> a écrit :

> Hi Alex,
>
> > Bear in mind that you have to keep the mouse button pressed down. If
>
> > you just right mouse button click, I've found that the context menu
> > only appears briefly before disappearing.
>
> Uhm, indeed, it disappears immediately after releasing the mouse. I
> wouldn't say this is expected behavior ... Do we already have an
> issue
> for this?
>
> Ciao
> Frank
>
> --
> - Frank Schönheit, Software Engineer         frank.schoenheit@...
> -
> - Sun Microsystems                      http://www.sun.com/staroffice
> -
> - OpenOffice.org Base                       http://dba.openoffice.org
> -
> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
> -
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@...
> For additional commands, e-mail: users-help@...

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Frank Schoenheit, Sun Microsystems Germany]

Hi Alex,

> I haven't opened one, or even searched on IT for one, so don't know,
> I just lived with it and explained to my users  ;-) That's not to say
> I wouldn't like it fixed though :-))

Sigh. You know that only bugs which we know about will be fixed, don't
you? :-\

I found this annoying enough to do a little investigation, and have a
fix for our AWT toolkit at hand. I'll commit if/when you give me an
issue ID :)

Ciao
Frank

--
- Frank Schönheit, Software Engineer         frank.schoenheit@... -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Base                       http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Alex Thurgood]

Hi Frank,

Your wish is granted ;-)

http://www.openoffice.org/issues/show_bug.cgi?id=104193


Alex

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Frank Schoenheit, Sun Microsystems Germany]

Hi Alex,

> http://www.openoffice.org/issues/show_bug.cgi?id=104193

thanks a lot, fix committed ...

Ciao
Frank

--
- Frank Schönheit, Software Engineer         frank.schoenheit@... -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Base                       http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...