Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Blob field question
Fri, Mar 31 2006 12:17 PMPermanent Link

"Stanimir Petkov"
Sorry for the dummy question,
Any tips for the following.
-Storing a file into a blob field
-Open file and edit woth the corresponding application
-Store back to blob
What is better to use, temporary files or some OLE technics.
Cheers
Stanimir

Fri, Mar 31 2006 3:41 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Stanimir,

<< -Storing a file into a blob field >>

To load from file:

TBlobField(MyTable.FieldByName('MyBlobField')).LoadFromFile('c:\temp\mypicture.jpg');

To save as file:

TBlobField(MyTable.FieldByName('MyBlobField')).SaveToFile('c:\temp\mypicture.jpg');

<< -Open file and edit woth the corresponding application >>

You would need to use some basic OLE commands to do this.  See the Servers
tab under Delphi for more information on the OLE server component wrappers
in Delphi for MS Office.

<< What is better to use, temporary files or some OLE technics. >>

It depends upon the application and whether it surfaces the ability to load
streams into the application via its OLE server interface.

--
Tim Young
Elevate Software
www.elevatesoft.com

Sat, Apr 1 2006 4:20 AMPermanent Link

"Stanimir Petkov"
Tim,
Thanks alot.


Image