Connecting and searching in MS SQL Database using macros

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
mamkiks
Posts: 17
Joined: Sun Mar 25, 2018 1:00 pm

Connecting and searching in MS SQL Database using macros

Post by mamkiks »

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
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Connecting and searching in MS SQL Database using macros

Post by Villeroy »

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 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
mamkiks
Posts: 17
Joined: Sun Mar 25, 2018 1:00 pm

Re: Connecting and searching in MS SQL Database using macros

Post by mamkiks »

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
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Connecting and searching in MS SQL Database using macros

Post by Villeroy »

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 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
mamkiks
Posts: 17
Joined: Sun Mar 25, 2018 1:00 pm

Re: Connecting and searching in MS SQL Database using macros

Post by mamkiks »

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
Post Reply