>I know I asked this before, but I want to double check and REALLY get into it this time, sirs! I am former FPW2.6 programmer and jumping into VFP 6.0 in creating an new application :)
>
>We are planning on creating an inventory application with VFP 6.0 and having the option for the user to see the picture(s) of an inventoried item. There can be 1 OR MORE images (pictures) PER ITEM.
>
>Let's say we would have about 5,000 items recorded in the inventory application and we have 3,500 pictures OF THE 3,000 items. That means only 3,000 items have pictures and IN THOSE 3,000 items, some would obviously have more than 1 pictures.
>
>Now, to be able to do this (as this is what "everyone" is telling me), I would need to create many many many directories for those images (*.jpg), such as:
>
>
- M1111111 <1 image> copymach.jpg
>thus:
>P:\INV\IMAGES\M1111111\copymach.jpg
>
>- M1222222 <1 image> computer.jpg
>thus:
>P:\INV\IMAGES\M1222222\computer.jpg
>
>- M1333333 <2 images> desk.jpg and chair.jpg
>thus:
>P:\INV\IMAGES\M1333333\desk.jpg
>P:\INV\IMAGES\M1333333\chair.jpg
>
>and so on...
>
>And then in the form, have a list box listing whatever (*.jpg) is in that directory of the same item ID. The list would show the name of the file (example in M1333333 - "desk" and "chair" in the list box). Upon clicking the name on the list box, the image would display (somehow and in "read-only").
>
>In this example, I would have to MANUALLY create 3,000 sub-directories. Does this make sense to you or is this how you do it or is this what you would suggest???
>
>I am posting this message in two places:
>www.levelextreme.com as "Visual FoxPro in general"
>comp.databases.xbase.fox
>
>If you can not be of any help replying this, but want to help anyhow, you may copy this (or forward) to another VFP newsgroups or to your expert friends who programs in VFP. Thanks for any reply.
>
>Chuck
>CNT@bfs.uwm.edu
I am working actually on an image database and I choose the system to have a reference to the high resolution picture and in my memo field I keep just a little thumbnail (128x128 256 colors). It works today with a database with 16000 pictures in jpg format and the thumbnails database is not bigger than 60 Megas. I keep the high resolution pictures on CDRom or a big hardisk...
To display the pictures fast, I use Espia Libraries...
Hope it helps !
Gilles
