I have done this using code AND directly. I do not remember off hand for
certain, so if you have not figured this out, email me and I will do it
again to remind myself.
But.... I think that I did the following:
* Create a database wit the longvarbinary (as you stated)
* Create a form that will display an image.
* Run the form.
* Right click on the image control (while the form is running)....
Or was that double click on the image control....
I need to go to work now so I can not verify any of this now.
B. Flowers wrote:
I'm using version 2.01. IMy Operating system is Windows XP. I have been working
through the beginers tutorial on the Openoffice Forum. I have strted my own
database to keep track of my garden. I can't figure out how to insert a picture
in my form without using code. I'm very close.
1) I have two table both with primary keys.
The Photo table contains: ID INTEGER [INTER]
ROSEPHOTO IMAGE [ LONGVARBINARY]
ROSENAME TEXT [VARCHAR]
ROSENUMBER TEXT [VARCHAR]
The Rose table contains IDPlant INTEGER [INTER]
PHOTO IMAGE [ LONGVARBINARY]
NOTES TEXT [VARCHAR]
ROSENUMBER TEXT [VARCHAR]
( AND MORE TEXT STUFF)
I have one form, it has a" image box" I open the Forn Navigator dialog, Selected the MainForm object,brought up a pop-up menu and select new Form. Renamed the the new form Photo. I open the the form properites dialog for the photo form. On the Data tab I set the following:
Content Type= Table, content Photo, Navagation bar yes, Master Link = Plant ID, Photo, Rosenumber. CommonName
Slave Link = ID, RosePhoto, Rosenumber, RoseName
THEN I DID THE SAME THING ON THE ROSE TABLE
Content Type= Table, content Photo, Navagation bar yes, Master Link = Plant ID, Photo, RoseNumber. CommonName
Slave Link = Plant ID, Photo, RoseNumber, CommonName
(((((( I can't
figure out Why the Master Slave are the same )))))))
NOTE: I did not create a subform when I opened the database and I did not
create any relationships in the beginning.
2.) In my table under the photo field, I see <OBJECT> . Is this correct? 3) My auto number is off by one number, It started at zero and I changed that to 1 and that was a mistake because the numbers are off by one. Can I fix this auto number?
Thank you Maggie
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info: http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
