How to make a Blob-"InplaceEdit"

hi friends,

a have a table with blobfields and a field which holds a Filename including the suffix.

how to find out the associated application,
Extract the blob, let user edit in the application,
and store back the changed document in the table.

i guess there are two possibilities
- an ole-solution
- a create-process solution

i'm interested in both

meikl
LVL 27
kretzschmarAsked:
Who is Participating?
 
simonetConnect With a Mentor Commented:
Ok, Meikl...

I'll prepare an application for you with all the necesssary code on it.

The code I have is actually part of a much larger project, but only 1 form (1 unit)  uses the DB->OLE-DB streaming mechanism. If you want the form as it is today, I have no problem with it, except that you won't be able to compile it right away. If you prefer it as it is now, I can send it to your right away.

Yours,

Alex
0
 
simonetCommented:
I've done that and OLE is definitly the way to go.

By using TBlobStream, I was able to load/unload the object to/from a TOLEContainer, which handled the editing of the component (by the OLE subsystem).

If you need the routines I used for streaming the OLE data, I can send to you through e-mail.

OLE is much easier because you don't have to worry about what kind of application you must open, where to find it, etc. OLE does all that.

Yours,

Alex
0
 
men xinCEOCommented:
kretzschmar:

Which kind of files?

menxin
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
kretzschmarAuthor Commented:
hi alex,

yup, sounds good,
i would like to see your ole-streaming-routines.
send it to
meikl@spektracom.de

i would also prefer to use ole, because,
as you said, it would be easier.

if i can get it applicable,
with use of your routines (if allowed),
then the points are yours (A-Graded, of course)

meikl ;-)
0
 
kretzschmarAuthor Commented:
to menxin,

for future all kinds of documents like
- pictures, multiple formats
- office docs (excel,word,...)
- visio docs
and more

the focus at the moment is on
- office docs (excel,word,project,powerpoint)
- visio docs

meikl
0
 
kretzschmarAuthor Commented:
hi alex,

it doesn't matter that i won't be able to compile it, as it is today, because i must it anyway adapt to my needs, therefore be free to send it right now as it is.

looking forward, to see, how you have solved that

meikl ;-)
0
 
simonetCommented:
Meikl,


I just sent olddb.zip to meikl@spektracom.de

Yours,

Alex
0
 
simonetCommented:
Oh, by the way... before running the project, change the databasename property of Table1 to the folder where you unzipped the sources. Then set its active property to True.

Yours,

Alex
0
 
simonetCommented:
Meikl, did you receive my e-mail?
0
 
kretzschmarAuthor Commented:
hi alex,

sorry for delay,
(sunday is family day and
i've stolen me to my homeoffice :-))
well have received your mail,
have taken a short look,
and seems to be what i need.

its night now here,
and i go to bed now,
i take tommorrow a closer look
and let you know

thanks for that you taken your time for me

good night

meikl ;-)
0
 
kretzschmarAuthor Commented:
hi alex,

had done a closer look,
and i can easy implement your suggestions on
how could it be done into my current project

man thanks for your help and time

meikl ;-)
0
All Courses

From novice to tech pro — start learning today.