Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


You can probably find a few examples using StarBasic in

http://www.pitonyak.org/database/AndrewBase.odt

On 08/03/2011 08:01 PM, opticyclic wrote:
I want to create a spreadsheet that connects to a customers database and
pulls out statistical info into various sheets and presents it nicely.

I am using a portable version of LibreOffice with an appropriate JDK/JRE and
ojdbc6.jar in a sub-folder.

My first step is to connect to the Oracle database.
I can do it by opening Base and putting in the JDBC connection details and
username /password.
I can then go back to Calc and use it.
However, when I go to a client it will be a new connection and I'd rather
just click a single button rather than flip around between 2 applications
setting things up.

How would I do these steps using a macro?
i.e.
take the connection details from a range in the sheet (the customer would
enter these details)
create a new connection to Oracle
run an sql query
put the output onto a new sheet

I'm proficient in Java and VBA but I am new to LibreOffice macros so I just
need some pointers on how to get going.


Thanks


--
View this message in context: 
http://nabble.documentfoundation.org/Connect-To-Oracle-Via-JDBC-Using-Macro-tp3223937p3223937.html
Sent from the Users mailing list archive at Nabble.com.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.