[Solved] Error in LibreOffice Base Access2Base Module 'Apn'

Discuss the database features

[Solved] Error in LibreOffice Base Access2Base Module 'Apn'

Postby Frie » Fri Mar 24, 2017 7:15 pm

Today I've upgraded LibreOffice to 5.3.1.2 but now I have Macro's that produce an error.

I have done some programming in Base with Access2Base but now the database connection gives an error in Sub DBOpen as it does not recognize 'ThisDataBaseDocument' any more.

When I try to execute the Access2Base module 'Application' in the editor screen it gives the following error:

BASIC syntax error. Expected: )

and it stops in Function HtmlEncode, where indeed the ")" is missing in line:

sOutput = sOutput & Utils._UTF8Encode(Mid(pvString, l, 1).

Who can help me?
Last edited by Frie on Sun Mar 26, 2017 1:23 pm, edited 3 times in total.
Ubuntu 14.04 LibreOffice 5.3.1.2
Frie
 
Posts: 2
Joined: Fri Mar 24, 2017 7:07 pm

Re: Error in LibreOffice Base Access2Base Module 'Applicatio

Postby Villeroy » Fri Mar 24, 2017 8:01 pm

The error is obvious, isn't it?
The latest version of LibreOffice seems to have a problem with trailing braces when they are missing. All other versions had no problem with this syntax error.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26976
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Error in LibreOffice Base Access2Base Module 'Applicatio

Postby Frie » Fri Mar 24, 2017 8:29 pm

Thank you, but who is going to solve this? Who should I contact?
Ubuntu 14.04 LibreOffice 5.3.1.2
Frie
 
Posts: 2
Joined: Fri Mar 24, 2017 7:07 pm

Re: Error in LibreOffice Base Access2Base Module 'Applicatio

Postby Villeroy » Fri Mar 24, 2017 9:32 pm

Frie wrote:Thank you, but who is going to solve this? Who should I contact?

The problem is known already: https://bugs.documentfoundation.org/sho ... ?id=106529
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26976
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Error in LibreOffice Base Access2Base Module 'Applicatio

Postby Villeroy » Sat Mar 25, 2017 11:27 pm

I attached to bug report https://bugs.documentfoundation.org/sho ... ?id=106529 a zip archive to fix all Basic modules shipped with LO 5.3.1.2.
https://bugs.documentfoundation.org/att ... ?id=132144
Shut down LO completely and run:
Code: Select all   Expand viewCollapse view
sudo unzip -o ~/Downloads/fixed_basic_modules.zip  -d /opt/libreoffice5.3/share/basic/

where ~/Downloads/fixed_basic_modules.zip is the zip file in the current user's Downloads folder and /opt/libreoffice5.3/share/basic/ is the basic folder in my installation path of LO 5.3.1.2.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26976
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Base

Who is online

Users browsing this forum: No registered users and 9 guests