Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is the dbf format to hold an image
Message
From
06/04/2017 10:07:27
 
General information
Forum:
Visual FoxPro
Category:
Pictures and Image processing
Miscellaneous
Thread ID:
01649850
Message ID:
01649878
Views:
98
>>>>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.
>>
>>If you're sending this HTML to the client and you don't have images on the server accessible by the client, then the above is not going to work. You need to embed images in HTML.
>
>Client has now come back and said they dont need the picture - great
>
>What is the VFP progam code for converting a dbf to htm?

See my initial replies.... For a quick solution check "How to: Save a Table as HTML" in Help.

If you don't want to read Help, here's the process:

  1. Open the table in a browse window.

  2. On the File menu, click Save As HTML.

  3. In the Save As HTML dialog box, click the option you want.

  4. To specify a different location to save the file, click the ellipsis (...) button. Otherwise, click OK.



>Thanks for all your help - jealous about you trip to Israel
Previous
Reply
Map
View

Click here to load this message in the networking platform