Dick
I store all of the student pictures outside of the database.
I get file name from PictureFilenames and assign that to the variable
vPicture.
variables in the form
1 : TEXT vJPGFile = JPGFileName IN PictureFileNames WHE StudentID =
StudentID
2 : TEXT vPicture = ('O:\DBSHARE\SA\PICTURES\'+.vJPGFile)
I place a variable image object on the form and then assign the
variable vPicture to it.
I'm sure there are other ways to do this but it works for me.
Buddy
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Dick Fey
Sent: Friday, July 01, 2011 11:39 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Storing pictures outside the database
Using 9.1, latest build.
Our product photo database is growing and starting to slow things down.
We have found that having pics of all our products instantly available
would be very helpful.
Therefore we are looking at putting all 8000 of our product pics on
file.
I know I have seen discussion on this board about storing jpeg's outside
the database, but cannot remember how to access the archives.
I assume you just store the address in the database, and call the jpeg
from the outside file as needed.
Any tips on doing this in the most efficient way, particularly
regarding how to load them into a form viewer would be appreciated.
Thanks,
Dick Fey
Carpet Broker Inc.
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected] In the message SUBJECT, put
just one word: INTRO ================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected] In the message SUBJECT, put
just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected] In the message SUBJECT, put
just one word: SEARCH-n (where n is the number of days). In the message
body, place any text to search for.
================================================