Well, what you are describing, is probably getting the data straight from the database. This works, but I want to do it from a macro. I want to have a TextField where the user can fill in the databaseID and then click on ok. On click, a query is performed, using the text in the TextField as a variable. From this result the data should then be displayed. I already can display other data from the resultset, I only have a problem with the image. So I need to somehow send the BinaryString which is in the database, to the ImageControl to be displayed. I hope this clarifies my problem a bit.
Cheers, Willem On 5/18/06, Ross Johnson <[EMAIL PROTECTED]> wrote:
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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
