Dragan
That's great and it works - presume the same for any other image format?
Now the second part of the problem - now I have the image in my vfp table I want to transmit the table to my Clients so they can at their end extract data and images for whatever purpose thay need - don't ask me why as the explanation would take too long - but I have been asked to transmit as a single file rather than a data file and a separate image file
Most dont use XML - if I transmit the file as HTML how do they extract the image - or is there some other way of transmitting the file to make it wasy for the recipient to extract the data and the image separately?
Thanks for your help
Colin
>>Hi
>>
>>Can I store a bmp image in a VFP table field? if so what field type would I use? - how would I store it in the field? - how would I subsequently extract tha image again as a stand alone bmp image?
>
>I'd recommend to keep the image outside of the table - easier to manipulate, and no memo bloat if you update the content. If you must, then check commands like Append Memo and Copy Memo (and make sure your memo fields are set with NoCpTran, i.e. as binary). Alternately, you can fill the memo with
>
>replace mymemo with FileToStr("my.bmp")
>
>and copy out of it with
>
>strtofile(mymemo, "my.bmp")
>
>Keep in mind that bmp is pretty much the only not-compressed format out there (one of the reasons why in the nineties and later the hardware sellers were smiling when you said you wanted a machine to run Windows - it took MS some time to confess there are JPG, GIF and PNG). Also, for the same reason do not use general fields, because they contain a preview of the actual content in... bmp format. Often a 5k jpg makes for a 500K general field, because it represents a large bitmap (low in detail so it compressed well).
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing