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

emfocuser · Newbie Joined: 14 Jun 2007 Posts: 4 Location: Madison, WI

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

Villeroy · Posted: Sun Feb 06, 2011 1:39 pm Post subject:

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

emfocuser · Newbie Joined: 14 Jun 2007 Posts: 4 Location: Madison, WI

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

Villeroy · Posted: Sun Feb 06, 2011 2:41 pm Post subject:

http://www.kalitech.fr/clients/doc/VB_APIOOo_en.html
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

emfocuser · Newbie Joined: 14 Jun 2007 Posts: 4 Location: Madison, WI

This'll get me started.
Thanks