Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
JPG files into foxpro general fields
Message
From
30/10/2001 12:51:10
 
 
To
30/10/2001 12:24:45
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00575169
Message ID:
00575184
Views:
42
>How do you programically put jpg files into foxpro general fieids?

Doug,

There are at least 2 problems with storing JPEGs directly in general fields.

First, if you want to display the picture on a form, you will either have to use an OLE server to display the image, or you will have to export the JPEG back out a file to use the picture control.

Second, I believe the table will grow to be *much* larger than the size of the original JPEG files.

If you really need them stored in the table, you suppose you can use a memo field. Use the FILETOSTR() function, and then store the string into the memo field.

You gain a lot of flexibility by simply storing the name of the file in the table. It very easy to display pictures on forms and print them on reports using this technique.

See Thread #495154 Message #495154 for a little more discussion.

HTH,
Steve Gibson
Previous
Reply
Map
View

Click here to load this message in the networking platform