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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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
simonetCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Delphi

From novice to tech pro — start learning today.