Willem Ligtenberg wrote:
Hi,
I'm writing a macro that performs a query on the database and puts the
result of the query on screen (in a form). Since the query will result
in only one result.
I am able to display text and date fields. But I also want to be able
to show a picture that is stored in the database. How do I get an
ImageControl to display that image, which is stored in binary format
in the database?
The Image Control should work fine (ref OOo 2.0.2 on Linux). I've only
used it on images that I've stored via the Image Control (right click
menu), so maybe that is important. Otherwise, it was set up much the
same as other controls, i.e. specify the data field on the Data tab, and
that's it.
Problems I did find were: storing images is very very slow for some
reason (may not be OOo's or the control's fault - I haven't tracked this
down yet), and; I would like better scaling/cropping options. Currently
all you can do is turn scaling on or off - which either distorts the
image if the image and frame have different aspect ratios, or clips the
image if the image is larger than the frame. I.e. neither option seems
optimal. So going the macro route may be the better way in the end.
Ross
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
