>can I include a small jpg file (~20k in size) in a blob field in a cursor and then include that in the XML created there of for uploading to a website?
>
>and how does on get it into the blob?
>
>Thanks
>
>Peter
I do not understand, what you want to store in XML file. I am under impression that XML file is a storage for data, not pictures. Am I missing something?
Probably you may work with HTML file instead. If it is the case, you could create a table, populate it as needed for blob field, like
REPLACE flblob WITH CAST(FILETOSTR(lcfile) AS BLOB))
- Then you can create a report and add the image there based on blob field as it is described in Message #
962475.
- and finally you can create HTML file using reportlistener:
o = NEWOBJECT("HtmlListener", HOME()+"ffc\_REPORTLISTENER.vcx")
o.TargetFileName="outfile.html"
REPORT FORM reportname OBJECT o NODIALOG NOWAIT
.....
Good Luck