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