| View previous topic :: View next topic |
| Author |
Message |
RPG
Super User
Joined: 24 Apr 2008
Posts: 2696
Location: Apeldoorn, Netherland
|
|
| Back to top |
|
 |
MSPhobe
Super User
Joined: 29 Sep 2005
Posts: 529
Location: England
|
 Posted: Mon Jul 06, 2009 12:36 am Post subject: |
 |
|
To reiterate something that appears above....
With ooBase 3.1, the issues of images in an ooBase database have changed.
It is now relatively painless to have images in a FORM EITHER by importing the image into the database (beware having a huge database!) OR by storing a link in the database, but this still allows you to see the image on THE FORM.
As of ooBase 3.1 adn SRB 1.1, you can have images on a REPORT if the image is stroed inside the database, but you can't (yet!) have images in a REPORT from mere links.
More at...
http://sheepdogguides.com/fdb/fdb1imag.htm |
|
| Back to top |
|
|
Ferro
Newbie
Joined: 30 Oct 2009
Posts: 2
Location: India
|
| Posted: Fri Oct 30, 2009 5:44 am Post subject: |
|
|
Many Thanks to the Almighty I visited this thread. & also to RPG for such a nice explanation
I use base for storing customer details for which I need to link the face pic. first I used Image object to save images directly into database.(I use ooo 3.1.1) but soon enough the size of db got huge. 
It use to hang my PC consuming time & resource even to update any record.
when I was searching for solutions I hit upon this thread. its so wonderful.
I now store all the images in directory and only save the filename in database. so whenever I work on the form it automatically fetches the image from the directory without consuming any time or resource.
Thanks all to RPG !! keep up your good work man.
I need help in writing macros (never wrote before) how to see functions of an object suppose for eg
oImageCtl.ImageURL
where can we see the complete list of sub functions like ImageURL in this case.
I tried searching in help file but couldn't find.
I would appreciate if you can provide me any link where it lists all functions of an object accessible in writing macro. |
|
| Back to top |
|
|
RPG
Super User
Joined: 24 Apr 2008
Posts: 2696
Location: Apeldoorn, Netherland
|
| Posted: Fri Oct 30, 2009 6:28 am Post subject: |
|
|
Hello
I don't understand the question.
When you have all image in your database and want change this to have only the URL in your database then there is no easy solution on this moment. You can only add the url by hand.
When you double click on the image then there comes a popup in which you can select the image.
I don't know if this answer your question
Romke |
|
| Back to top |
|
|
the79bomb
Newbie
Joined: 16 Nov 2007
Posts: 4
|
| Posted: Wed Feb 24, 2010 4:45 pm Post subject: Re: how to add images to base, with and without using path |
|
|
Ran through this today and only found 2 changes with 3.2
| dbojan wrote: |
4. Editing form ...
In MENU select VIEW/TOOLBARS/FORM CONTROLS.
Click on third icon from the back on "FORM CONTROLS toolbar".
It is called "MORE CONTROLS"
on "MORE CONTROLS toolbar" click on third icon from the beginning.
It is called "IMAGE CONTROL"
|
In 3.2 for me "Image Control" is the 4th button. Do not confuse this with "Image Button" (the third button) - it will not work
Also in the macro code:
| dbojan wrote: |
dim oImageCtl as object
dim oFormCtl as object
dim sImagePath as String
oFormCtl = ThisComponent.Drawpage.Forms.getByName("MainForm")
oImageCtl = oFormCtl.getByName("ImageControl")
sImagePath = "C:\" + oFormCtl.getColumns.getByName("code").getString + ".jpg"
oImageCtl.ImageURL = ConvertToURL(sImagePath)
|
The line: oImageCtl = oFormCtl.getByName("ImageControl") )
needs to be updated to relect the new default name "Image Control 1" like this:
oImageCtl = oFormCtl.getByName("Image Control 1")
Here is the updated macro code:
| Code: | dim oImageCtl as object
dim oFormCtl as object
dim sImagePath as String
oFormCtl = ThisComponent.Drawpage.Forms.getByName("MainForm")
oImageCtl = oFormCtl.getByName("Image Control 1")
sImagePath = "C:\" + oFormCtl.getColumns.getByName("code").getString + ".jpg"
oImageCtl.ImageURL = ConvertToURL(sImagePath) |
_________________
Beer is living proof that God loves us and wants us to be happy. - Benjamin Franklin |
|
| Back to top |
|
|
tukiel
General User
Joined: 09 Jul 2010
Posts: 8
Location: Mexico
|
| Posted: Sun Jul 11, 2010 10:08 am Post subject: |
|
|
| This was the next step for my userID database.. getting the images out of the database. I was about to post a question, but I found this already answered and will try it instead. Thanks RPG. |
|
| Back to top |
|
|
musicstave
Newbie
Joined: 03 Feb 2012
Posts: 3
|
| Posted: Fri Feb 03, 2012 1:46 am Post subject: Issue with Version 3.3? |
|
|
Hi Everyone.
I've followed these directions to the T (I hope) but it does not work.
The embedded images instructions worked fine. 
Unfortunately its the linked images directions with the issues, and I used the original and new macro code provided by the79bomb. 
It is possible to adding an image to record 111
When going to 222 the image from record 111 stays in the image control box. If I double click and select a new picture it changes to the new image.
When I return to record 111 the image for record 222 is displayed. It seems to have forgotten the link/location for record 111.
If I change the image for 111 (again) and go to 222, image for 111 is displayed.
Is it me, or is there something different about version 3.3?
Many thanks in advance.
Regards
Musicstave. |
|
| Back to top |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Fri Feb 03, 2012 2:22 am Post subject: |
|
|
Works for me. The picture changes when I store the text value.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
musicstave
Newbie
Joined: 03 Feb 2012
Posts: 3
|
| Posted: Fri Feb 03, 2012 3:26 am Post subject: Issue with linked images. |
|
|
I neglected to state my version 3.3 on Mac.
I will try to uninstall open office and reinstall. It did crash several times when first using so maybe there was a problem on install. |
|
| Back to top |
|
|
musicstave
Newbie
Joined: 03 Feb 2012
Posts: 3
|
| Posted: Fri Feb 03, 2012 6:20 am Post subject: |
|
|
| Villeroy wrote: | | Works for me. The picture changes when I store the text value. |
After uninstall an new installation, the problem still persists.
Im guessing its because a HD on a Mac is not called a C drive.
I'm guessing Villeroy is using Windows?
In learning how to do this, Im attempting to make this work with the image library in dropbox, and the database, in the same directory, to work from either Mac or Win.
Does anyone have a solution?
Thank you in advance
Regards |
|
| Back to top |
|
|
RPG
Super User
Joined: 24 Apr 2008
Posts: 2696
Location: Apeldoorn, Netherland
|
| Posted: Fri Feb 03, 2012 8:56 am Post subject: |
|
|
Hello
I donot complete understand your question.
For an image it is enough to insert the url for the image. I did have test this also the url for a image on the internet. There is also no need more for a macro.
Maybe you have to make two control for the same field.
a control for showing the image and a control for inserting the URL.
Maybe this link can help you more.
Romke |
|
| Back to top |
|
|
|
