>>>what is the dbf format to hold an image
>>
>>Memo nocptrans (i.e. binary). You can use General field, which is practically the same thing.
>
>
>Thanks
>
>I have the name of the image file in the dbf eg bigimage.jpg
>
>bigimage.jpg is a filte on t:\stock
>
>How do I add the actual image to my dbf and then convert it to htm?
You don't convert it into html - html is not a database, you show it in html. In your code
lcFileUrl="File:///"+Chrtran(lcFullPathToJpg, "\", "/")
TEXT TO c NOSHOW TEXTMERGE
<html>
<p><img src="<<lcFileUrl>>"> </p>
</html>
ENDTEXT
Now variable c contains the html with just image and nothing else - no proper header, no attributes (size, for example), but it would show.
strtofile(c, "fullpath\your.html")
and then use your favourite way of passing the page to a browser, and there it is. Mind you, the file MUST exist on disk (unless you want to experiment with inline images, base64 encoded, which I see done from time to time but never did myself), so storing it in a dbf is kind of redundant, unless you want to keep them in there, copy to disk as needed, remove when no more needed.
