Ken,
G is internally M but what would this help for? How would this strip out OLE header?
Cetin
>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.