Commit changes to a odb db through a macro

[scananza]

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.

[Villeroy]

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 http://forum.openoffice.org

[scananza]

Hi,
I'll post it in the base forum, thank you