What to Do to use picture under jpg

[satendra1972]

Sir/MAM
I am recently developing a Package named as "Fabric Management System" for my company while using Foxpro2.6 under Windows. I had to show the sample fabric color while
in my programme. I had created a Master database with name Color.dbf having field code,description, style & opening balances. Once i niput all the data. I have to use the same dbf for Fabric Studio. I just want to know how to input picture under jpg format in a dbf. My Foxpro is not accepting type "Picture" while creating a dbf.
Is there any programming method to convert jpg file to bmp as foxpro does not support jpg. I hope for quick help
on to my mail satendra_kam@yahoo.com

Regards,
Satendra

 

[DSummZZZ]

You will probably have to find a utility somewhere that does this either batch mode or from within the program by using a RUN command when you are adding the picture file as there is nothing native to FoxPro that can do that. Or you will have to use OLE and a 3rd party viewer of some sort to display the picture programmatically if you don't convert it.

Try something like this:

http://download.cnet.com/downloads/0-10077-100-1426659.html?tag=st.dl.10001-103-1.lst-7-7.1426659

Dave S.

 

[dgrewe]

I would hate to see the spped of your application after severl hundred JPG file were added to a memo/general field.
I agree with DSumm, Make a field in your database called filename.
Create a sub-Directory under you application root called images.
use the run command or windows API calls to start a viewer program

http://ibs.internationalbid.net/home/dave/code_html/runexe.html

David W. Grewe
Dave@internationalbid.com

 

[Scott24x7]

Satendra,
I've had a lot of experience in OLE objects & Fox2.6. For your best manipulation under images, I highly reccomend converting the images from a .JPG to .BMP format. It becomes far easier in fox to deal with them. In addition, I reccomend coming up with a "Standard" for your images. Figure exactly how big your image will be when displayed (in pixels, such as 200x300 pixels). Then, using something like Photoshop, adjust all of the images so that they are the exact same size. This will help keep file sizes to a minimum, and image quality no greater/lesser than is absolutely required.
Also, Genereal fields can be a little flaky. I reccomend capturing any "OLE Fields corrupt" type messages, and actually discarding them. My experience has shown that they are erroneous, and will actually CAUSE problems. You may, on a rare occasion actually have a corruption, but they are drastically reduced when ignoring them in general.
Please let me know if this helps.
-Scott