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

Commit changes to a odb db through a macro

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


Joined: 28 Sep 2005
Posts: 32
Location: Udine - Italy

PostPosted: Thu Nov 02, 2006 8:21 am    Post subject: Commit changes to a odb db through a macro Reply with quote

Hello,
working with odb database and calc spreadsheet I've come through this problem:

my calc spreadsheet is connected through a form to a odb database; I've written a couple of macro that insert db data into the spreadsheet when user selects an item in a dropdown menu, this works correctly.
Then I wrote a macro to do the opposite job, inserting data from spreadsheet to odb db: it _seems_ to work in the sense that after the macro is run new data appear in the dropdown menu but they are not effectively committed to the db file and when the document is cloesd data are not in the db anymore. I noticed that if I push the data source button and I connect to the db by there new data are swapped to the file, so my question is: how can I accomplish this through a macro?

thanx a lot.
Back to top
View user's profile Send private message Visit poster's website
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Thu Nov 02, 2006 9:20 am    Post subject: Reply with quote

Hi,
This is the wrong forum. You should search the Base-forum, the API-forum and the Snippets-forum on this site.
Get Andrew Pitonyak's excellent http://www.pitonyak.org/database/AndrewBase.odt
I guess you have to convert all your spreadsheet-values(string or double, maybe error) to the appropriate types of your database or put them into form-controls.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
scananza
General User
General User


Joined: 28 Sep 2005
Posts: 32
Location: Udine - Italy

PostPosted: Thu Nov 02, 2006 11:43 pm    Post subject: Reply with quote

Hi,
I'll post it in the base forum, thank you
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc 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