>>I'm fully agree with you, storing the pictures in the table is a pain. The table will grow and grow, and search times will be going down. I always store only the path.
>
>I see what you're saying and it makes sense to me. But if I store the path/filename to my picture, how can I print the picture in a report using the FoxPro reportwriter? In my case I'm actually printing Product Labels with part numbers, descriptions and a picture of the product.
It is so easy, you'll slap yourself with the trout :)
In the report writer, add a picture field. In properties of the picture, use the FILE entry (not the FIELD entry). In FILE, put the cursor field that holds the full path of the file (eg. tmpCursor.fullFileNameofPictureFile).
Of course, you just need to have the full path of the picture files as a part of your SELECT statement b4 running the report.
HTH,
Steve Gibson