Connecting and searching in MS SQL Database using macros

Creating a macro - Writing a Script - Using the API

Connecting and searching in MS SQL Database using macros

Postby mamkiks » Wed Apr 04, 2018 7:06 pm

I need to search using macros in writer if some data existing in "MS SQL Server" Database or not
OpenOffice 4.1.5 on Windows 10
mamkiks
 
Posts: 17
Joined: Sun Mar 25, 2018 1:00 pm

Re: Connecting and searching in MS SQL Database using macros

Postby Villeroy » Thu Apr 05, 2018 9:37 am

You dont need any macros. Connect a database document to the database and use the built-in filter tools.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 25579
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Connecting and searching in MS SQL Database using macros

Postby mamkiks » Thu Apr 05, 2018 11:41 am

Villeroy wrote:You dont need any macros. Connect a database document to the database and use the built-in filter tools.

Sorry but I couldn't understand how it works.

I need to use macro to search for value in MS SQL Server Database and return values
OpenOffice 4.1.5 on Windows 10
mamkiks
 
Posts: 17
Joined: Sun Mar 25, 2018 1:00 pm

Re: Connecting and searching in MS SQL Database using macros

Postby Villeroy » Thu Apr 05, 2018 5:08 pm

Then write a macro but do not expect us to do your work.
If you don't even know how to connect a Base document to your database, all hope is lost anyway.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 25579
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Connecting and searching in MS SQL Database using macros

Postby mamkiks » Fri Apr 06, 2018 9:33 am

Villeroy wrote:Then write a macro but do not expect us to do your work.
If you don't even know how to connect a Base document to your database, all hope is lost anyway.


I didn't ask you to do my work
I'm asking about the configuration
In MS Word I'm using ADODB by adding ActiveX reference
then I need to know how to make this using OpenOffice

If you don't want to help me, you don't have to do this
regards.
OpenOffice 4.1.5 on Windows 10
mamkiks
 
Posts: 17
Joined: Sun Mar 25, 2018 1:00 pm


Return to Macros and UNO API

Who is online

Users browsing this forum: No registered users and 5 guests