MS WORD in Oracle Forms 6i

[Uli32]

Hello I'm new in Oracle Froms6i,
i have a table with a blob column in it.
In this column are MS Word MS Excel or rtf Data.
I will only display a little Icon in the form mask when
there is Data availabile.
When the user makes an doublclick on the field.
The File should by open in Word or Excel

Many thanks

Ulrich

 

[sem]

Use OLE Container item, it provides this functionality. You may also tune whether to open it within forms window or outside. Regards, Dima

 

[Uli32]

i make a ole container but i don't know what kind of
popertys i must use to disply this link

 

[sem]

Isn't it the default behaviour? Regards, Dima

 

[Uli32]

the default for an blob is image when i switch to a ole container and i use the defaults i only see the emty frame
from the ole container

 

[sem]

Does your field contain any data? Did you QUERY your table? Regards, Dima

 

[Uli32]

yes i make a quick query in the oracle discoverer
the files are existent in the blob column and the link between oracle discoverer and word or excel is ok

When i insert a document in the running form with the Insert objet option and i save it to the database i
can open it again only the stored one makes problem to open it.

 

[sem]

Is your OLE field a BASE TABLE one? Does it really reffer to some data within database? Did you see the update confirmation : x records applied and saved? Regards, Dima

 

[Uli32]

i saw the update replicaton
one row updated and saved, but what do you mean for BASE TABLE.
Here are the table specification
DK_LENR VARCHAR2 (16),
DK_PIDNR VARCHAR2 (16),
DK_NAME VARCHAR2 (150),
DK_COMM VARCHAR2 (150),
DK_USER VARCHAR2 (20),
DK_DATUM DATE,
DK_FTYP VARCHAR2 (4),
DK_FILE BLOB )

on DK_NAME,DK_PIDNR,DK_LENR are unique Index

I make a new form and only put this table in it
without any reffer to the database.
Sorry for this big thread and many many thx for your help

Uli

 

[sem]

All items may be either BASE TABLE items or NON BASE TABLE items. This means that even in block built on some table you may create items not bound to database fields. In this case the data entered will not be assigned to any table column and will not be saved in database. Regards, Dima

 

[Uli32]

ok i know what you mean, yes its a base table element.
What do you think about this idee, i make an non base table ole container and put the file with an trigger into it.
Is this possible ? and when procedur must i use to put the ole data into the field

Uli