You can manually set the field type character in the DBF to be a Memo field
For this to work, make sure the first field is the General field

Not sure where I found this code, I believe it was here.

There may be more intelligent code out there that parses the whole DBF structure for General fields. Anyway, this worked for me.

select em_photo from mydb where condition into dbf c:\temp.dbf

lnHandle = Fopen(lcfname,12) && open lowlevel to change

Fseek(lnHandle,43,0)

lctype = FREAD(lnhandle, 1)
IF lctype = 'G'
Fseek(lnHandle,43,0)
Fwrite(lnHandle,'M',1) && Changing General to Memo
ELSE
? lctype
WAIT 'not gen '
endif
Fclose(lnHandle)



>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.