Dick,
I am sure there are a bunch of ways to do this.
I set 2 variables, one to see if the file exists (In my case the "style"
name of the product corresponds to the name of the JPEG file name):
Vchk = (chkfile('f:\images\imagedir\'+style+'.jpg'))
The other to display a blank in the variable image if it does not exist (if
it does not exist I was getting a red X in the box):
Vimage = (ifeq(.vchk,1,('f:\images\imagedir\'+style+'.jpg'),'blank.bmp'))
Then I locate a variable image on the form sized to what I want and I check
off "Center" and "Proportional" on the properties.
Steve
Steve Vellella
Office: 409-944-3904
Cell: 520-250-6498
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Dick Fey
Sent: Friday, July 01, 2011 10: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.
