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

[Solved] Writing to Base from a Visual Studio 2010 a Base

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API
View previous topic :: View next topic  
Author Message
emfocuser
Newbie
Newbie


Joined: 14 Jun 2007
Posts: 4
Location: Madison, WI

PostPosted: Sun Feb 06, 2011 1:27 pm    Post subject: [Solved] Writing to Base from a Visual Studio 2010 a Base Reply with quote

Our main program is written using VB, with many C++ parts (which get called) All is compiled using Visual Studio 2010. We'd like to have the program write some of its data to a Base database. I see that Open Office Basic is a lot like visual basic, but that code is alled from within Open Office. To have our program write to base will I be able to use Open Office Basic, or should I concentrate on the C++ option, using the Developers guide?
p.s. Visual Studio 2010 seems to run fine on both 32 bit and 64 bit computers. We have some of each.
Thanks,
emfocuser


Last edited by emfocuser on Sun Feb 06, 2011 3:20 pm; edited 1 time in total
Back to top
View user's profile Send private message Send e-mail
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sun Feb 06, 2011 1:39 pm    Post subject: Reply with quote

Base is not a database program. The "integrated" HSQLDB is a caricature of a database (unsave, insecure, slow, unstable, losing data).
Create some database like MySQL, PostgreSQL, Oracle, MS SQL, stand-alone HSQLDB, whater SQL.

Then use Base as one frontend and your program as the other frontend. This way everything is properly separated from each other and you do not need to struggle with this hell of an API just because you want to write something into a database.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
emfocuser
Newbie
Newbie


Joined: 14 Jun 2007
Posts: 4
Location: Madison, WI

PostPosted: Sun Feb 06, 2011 2:09 pm    Post subject: Reply with quote

I know what you mean, about Base's limitation. However this is for a very limited purpose. It would be a single table. At least in the short term, I think base might be the most convenient.
Can I create a Sun UNO object by declaring it in our VB application instead of in Open Office?
emfocuser
Back to top
View user's profile Send private message Send e-mail
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sun Feb 06, 2011 2:41 pm    Post subject: Reply with quote

http://www.kalitech.fr/clients/doc/VB_APIOOo_en.html
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
emfocuser
Newbie
Newbie


Joined: 14 Jun 2007
Posts: 4
Location: Madison, WI

PostPosted: Sun Feb 06, 2011 3:15 pm    Post subject: Reply with quote

This'll get me started.
Thanks
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API 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