>Hey,
>I want to store the snaps(in JPEG Format) of employee to the database.
>I use a picture control to show this image on the form.
>While saving the snaps I can directly save it to the database using...
>
>APPEND GENERAL em_photo FROM z:\data\images\ku0001.jpg
>
>But while retriving the same, I am not able to do the same.
>Please suggest me a way out.
>Thanks in advance.
This has been told maybe a thousand times. Do not use general fields. If you 'have to' store the images in a table than prefer memo fileds (or BLOB in VFP9).
Store the path and filename instead.
If you don't have access to sources anymore you can do soething like this:
copy next 1 imagefield to tempCursor
lowlevel open the tempcursor's fpt
get data starting at offset 599 (599 works for BMP but not the same for all file types).
Cetin