> > Hi,
> >
> > How to append jpeg image file into a general field. It works with bmp file but with jpeg files I can only see the icon. The table is a temp table use for print the image on a report. After the report is printed, the table will be removed. Thanks
> >
>
> Better avoid the General field type entirely, the concept was never working well, and in the meantime even MS recommends not to use it.
> You can use FileToStr() instead, and store the file content in a BLOB or binary memo field. Or keep the file separately, and just store its full-path name.
>
>
> hth
> -Stefan


Hi Stefan,


The jpg images are kept separately in another folder and only its full path name is stored in a field 'imagelocation'. When printing report, I create a Cursor and refer to the field 'imagelocation' to point to the image folder and append the jpg to the Cursor general field. I am aware of the potential problems associated with storing the image files in the general field.


I am not familiar with FileToStr() concerning image file. Please advise how to deal with appending jpg image.

Many thanks
James