Saving Picture1.Image Into Database

[Off2Cabo]

Hello:

How do you save an image from a picture box into a database? Possibly, set the database field to OLE object? But how do you do that when the VisData Manager only gives you the option of: Boolean, Byte, Integer, Long, Currency, Single, Double, Data/Time, Binary and Memo?

Best To all, ---Steph

[This message has been edited by Off2Cabo (edited 10-08-1999).]

[SmithVoice]

You want to hold the graphic file's data in the database?

step by step demo source code at:
http://www.smithvoice.com/appendin.htm

If you want to hold the OLE information in the database then look to the OLE Control's documentation.

The field type is usually a BLOB or memo type depending on the engine. See the engine docs for your particular DBMS.

use VisData just to create the field, use code to manipulate the data.

-Smith

[Off2Cabo]

Clarification:

I understand that it is better to store images away from the db, in a disk file.

I would like to do that, if it keeps my db compact. However, the dilemma is how do I go about that? How can I store the image in a disk file, then use a text field in my db to call it? First of all, is that the best way? And secondly, how would you explain that to a complete moron? Any advice?

------------------
Email: Off2Cabo@aol.com
"Face Down In The Warm Cabo Sand"