Hi James,

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

Oh I see, that sounds like a good approach to me.

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

The FileToStr() function would return the entire file stream so that you can store the result string where ever you want

Create Cursor reportCursor (fileContent Memo NoCpTrans, fileName C(250))
Local lcFile
lcFile = GetPict('jpg')
Insert Into reportCursor Values ( FileToStr(m.lcFile), m.lcFile )

* and later, perhaps you want to recreate the file / save the content back to disc:
StrToFile(reportCursor.fileContent, 'x:\some\folder\newfilename.JPG')

However, in your case you might not even need to do so but rather use the "Expression Or Variable Name" option for the Control Source Type and your field name containing the full-path in the properties dialog of your OLE Bound Image control in the report?



hth
-Stefan