Solved

Delphi5,Oracle8i and Ms-word

Posted on 2000-02-15
10
290 Views
Last Modified: 2010-04-04
Hi experts,
I need store Ms-word documents in Oracle db.
 After i need, without save again this field in hard disk,start ms-word,open a document from my db.How?
  Thanks.
0
Comment
Question by:franzem
10 Comments
 
LVL 8

Expert Comment

by:ZifNab
ID: 2523707
mmm, so also when you changed the contents, you would like to save it directly to the database and not to HD? Why do you want to avoid the saving of the document from db to HD? This would surely make it easier. You can always delete the file from the HD when it isn't needed anymore.

Zif
0
 

Author Comment

by:franzem
ID: 2524003
Yes,the idea is not save nothing in HD only in DB. Preference without save intermediate files, there no way?
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 2524167
hi franzem,

this is not possible, word cannot direct edit a document in a db.
you must temporary extract the blob from the db atleast into memory, then you may edit it in an olecontainer.

if you don't want a ole-container,
then you have to extract the blob into a file and execute word.

meikl
0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 
LVL 10

Expert Comment

by:ptmcomp
ID: 2524517
I think it's possible if you use Word as inplace ActiveX. Then the file menu doesn't appear and you can create your own. You can load and save word docs as ole streams.
ptm.
0
 
LVL 2

Expert Comment

by:florisb
ID: 2526728
following... (...just storing links in the database is no option, hmmmm?)

F.
0
 

Author Comment

by:franzem
ID: 2527560
For Florisb :Now is make storing links.
For Kretzschmar and ptcomp:How,from memory streams load a Olecontainer or a ActiveX with Ms-word embeded?
0
 
LVL 15

Accepted Solution

by:
simonet earned 400 total points
ID: 2529305
I have written a program that does exactly what you want, by  using OLE and a BLOB field.

Although the program I wrote (for didatic purposes) uses a Paradox table, I have done the exact same thing with Oracle, and it worked great.

You can download the program, with full source code, from

http://www.bhnet.com.br/~simonet/extras/oledb.zip

It allows you to store a file in a BLOB field, and, through an OLEContainer, directly linked to the database, you can edit the document without needing the actual file. All changes are saved to the DB, rather than to the file. It also doesn't use "temporary files". Everything is done using streams between the BLOB field and the container. Anyway, the code is all there and if you have questions, feel free to contact me.

Yours,

Alex

0
 

Author Comment

by:franzem
ID: 2550692
OK. Alex yours points.
0
 

Expert Comment

by:oldgvozdik
ID: 12350589
this link does not work
0
 

Expert Comment

by:meldel
ID: 21272859
This link does not work.
Simonet, please can send an new link.

thanks
0

Featured Post

ScreenConnect 6.0 Free Trial

Want empowering updates? You're in the right place! Discover new features in ScreenConnect 6.0, based on partner feedback, to keep you business operating smoothly and optimally (the way it should be). Explore all of the extras and enhancements for yourself!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question