how to copy a bitmap in a general field to a jpeg file

[longda]

I have a table name empphoto with two fields the first is emp_num which holds the numeric value of the employees id number, the second is a general field which has a bitmap picture of the employee embedded in it. This is a 2.6 table and I want to save the picture in the general field to a seperate jpeg file with the name of file being the employee number. I cann't figure out how to copy out of the table. If anyone has any idea please help it is much appreciated.

dave long

 

[ChrisRChamberlain]

longda

I cann't figure out how to copy out of the table.

The simple answer is you can't.

There is no equivalent of COPY MEMO...

Rather than store the .jpg in a general field, store the filename reference in a field.

If you really need to embed the graphic file in a table, save it to a memo field and then copy it to disk.

There are a number of threads on this topic and you should find them with keyword searches.

Chris

 

[longda]

Chris,

Thanks for the info. The table was set up in foxpro 2.6 before I had started. The only way I have found is to it manually by double clicking on the general field to open mspaint and save it as a .bmp file then convert that to a jpeg. I was hoping there was a way to it through code. There is only 300 or so records so looks like I'm stuck doing manually. I will remember what you said so that I will be able to avoid problems like this in the future. Thanks again.

dave long

 

[anicoara]

I think you can use doVerb method, parameters can be different according to aplication used for visualisation.