> Hi James,
>
> >
> >
> > 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
Hi Stefan,
Thanks, your suggestion to use "Expression Or Variable Name" in the report works fine when I use VFP 9.0. VFP 8.0 does not have that properties setting.
Rgds
James