OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Writer and DataBase link

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Writer
View previous topic :: View next topic  
Author Message
Allan
General User
General User


Joined: 22 Oct 2004
Posts: 15

PostPosted: Wed Jun 07, 2006 1:30 pm    Post subject: Writer and DataBase link Reply with quote

Sorry, bit it's first time that I try to use DataBase and I can't do a link.
I explain.
I have an external Database and I would like to insert some columns (all rows) from DB.

The firs time, I insert well in choosing fields from table.
I close document.
I modify DB : update rows, delete row, insert row.
I reopen document, I would like to update automatically my database view in document (I tried "update All" from tools without any effect...) (as I can do with an OLE object for example).
May be, I didn't understand a good procedure to do, I searched on Internet, bit I didn't find how to do this.

Could you help me
WXP-PRO, OOo 2.0

Thanks

Allan
Back to top
View user's profile Send private message
Allan
General User
General User


Joined: 22 Oct 2004
Posts: 15

PostPosted: Thu Jun 08, 2006 8:39 am    Post subject: Reply with quote

I found a beginning of solution in inserting fields from Database (Insert/databases field) in array, with "next field" between each line.
1. I didn't find how to update these fields automatically when I open the document. (I need to show database explorer, select fields, insert fields).
2. I tried to register operation in Macro, but action in database aren't register.

Do I need to find good API in uno, or does it exist an action in writer to update fields each time in opening document (or with a macro) whithout selecting fields (in this case I will take only the n first row from table).

Thanks to your ideas.

Allan
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Writer All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group