[Solved] Free HSQLDB 0.3.7 problem LO 5.4.2.2
-
- Posts: 881
- Joined: Mon May 30, 2011 4:02 am
[Solved] Free HSQLDB 0.3.7 problem LO 5.4.2.2
Hi Villeroy,
It appears that every time a new LO is published the changes are such that your macro 'Free HSQLDB' has a problem.
Attached you will find the print screens.
I also have a question.
I would like to make 'Free HSQLBD' part of the database in stead of part of LO. With other words make it portable. Is that possible?
Dream
It appears that every time a new LO is published the changes are such that your macro 'Free HSQLDB' has a problem.
Attached you will find the print screens.
I also have a question.
I would like to make 'Free HSQLBD' part of the database in stead of part of LO. With other words make it portable. Is that possible?
Dream
Last edited by dreamquartz on Fri Nov 10, 2017 6:08 pm, edited 3 times in total.
LO 7.x, HSQLDB 2.7.x & Ubuntu 22.04 LTS.
Re: Free HSQLDB 0.3.7 problem LO 5.4.2.2
Everything is portable already.
Module "FreeHSQLDB" together with "Helpers" and the dialog does the connection job with a GUI for any active database document (ThisComponent). You are free to distribute the package.
Module "AutoInstall" together with "Helpers" does the connection job without any GUI and for the containing database document (ThisDatabaseDocument). Simply write the document specific values you would enter into the dialog to the constants declarations on top of the AutoInstall module. To call the auto-install macro you are free to use document specific menues, tool bars, (auto start-) events or some button on a form control.
Module "FreeForms" does something different with any database document (ThisComponent).
viewtopic.php?f=21&t=77543
Edit AutoInstall constants.
Assign your document's auto-open event.
Free forms if you want.
Wrap the whole directory (odb, database folder, driver folder and forms) into an archive.
On the target system:
Look up or set up a trusted directory in Tools>Options>Security>[Macro Security...] and extract the archive to a trusted directory. Trusted directories include subdirectories
Module "FreeHSQLDB" together with "Helpers" and the dialog does the connection job with a GUI for any active database document (ThisComponent). You are free to distribute the package.
Module "AutoInstall" together with "Helpers" does the connection job without any GUI and for the containing database document (ThisDatabaseDocument). Simply write the document specific values you would enter into the dialog to the constants declarations on top of the AutoInstall module. To call the auto-install macro you are free to use document specific menues, tool bars, (auto start-) events or some button on a form control.
Module "FreeForms" does something different with any database document (ThisComponent).
viewtopic.php?f=21&t=77543
Add the 2 modules to your database document. You may need to add some library if your document is free of Basic code so far (just a dummy Standard.Module1). Then Ctrl+Drag&Drop the 2 modules in the macro organizer.myself wrote:-- Added an auto-install module to this library, very much inspired by the brilliant work of DACM. Copy that module together with the "Helper" module into your distributable database document, adjust the constant values to your requirements and assign the document open event to Sub onDocumentOpen. It offers the same features as the dialog for any distributed package with a Base document, a hsqldb.jar, a HSQL backend and a collection of stand-alone forms with optional registration at the office suite.
Edit AutoInstall constants.
Assign your document's auto-open event.
Free forms if you want.
Wrap the whole directory (odb, database folder, driver folder and forms) into an archive.
On the target system:
Look up or set up a trusted directory in Tools>Options>Security>[Macro Security...] and extract the archive to a trusted directory. Trusted directories include subdirectories
Last edited by Villeroy on Sat Nov 04, 2017 8:48 pm, edited 1 time in total.
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 881
- Joined: Mon May 30, 2011 4:02 am
Re: Free HSQLDB 0.3.7 problem LO 5.4.2.2
Will look into it.Villeroy wrote:Everything is portable already.
Module "FreeHSQLDB" together with "Helpers" and the dialog does the connection job with a GUI for any active database document (ThisComponent). You are free to distribute the package.
Module "AutoInstall" together with "Helpers" does the connection job without any GUI and for the containing database document (ThisDatabaseDocument). Simply write the document specific values you would enter into the dialog to the constants declarations on top of the AutoInstall module. To call the auto-install macro you are free to use document specific menues, tool bars, (auto start-) events or some button on a form control.
Module "FreeForms" does something different with any database document (ThisComponent).
viewtopic.php?f=21&t=77543Add the 2 modules to your database document.myself wrote:-- Added an auto-install module to this library, very much inspired by the brilliant work of DACM. Copy that module together with the "Helper" module into your distributable database document, adjust the constant values to your requirements and assign the document open event to Sub onDocumentOpen. It offers the same features as the dialog for any distributed package with a Base document, a hsqldb.jar, a HSQL backend and a collection of stand-alone forms with optional registration at the office suite.
Edit AutoInstall constants.
Assign your document's auto-open event.
Free forms if you want.
Wrap the whole directory (odb, database folder, driver folder and forms) into an archive.
On the target system:
Look up or set up a trusted directory in Tools>Options>Security>[Macro Security...] and extract the archive to a trusted directory. Trusted directories include subdirectories
Thanks,
Dream
PS: what about the LO 5.4.2.2 issue?
LO 7.x, HSQLDB 2.7.x & Ubuntu 22.04 LTS.
Re: Free HSQLDB 0.3.7 problem LO 5.4.2.2
Which issue? The error? The error message tells you that there is no dialog library named "FreeHSQLDB" in the GlobalScope which is probably correct after you embedded the whole thing in a document and ran it on an office suite with no FreeHSQL installed.dreamquartz wrote:PS: what about the LO 5.4.2.2 issue?
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 881
- Joined: Mon May 30, 2011 4:02 am
Re: Free HSQLDB 0.3.7 problem LO 5.4.2.2
Did not migrate just yet to embedded.Villeroy wrote:Which issue? The error? The error message tells you that there is no dialog library named "FreeHSQLDB" in the GlobalScope which is probably correct after you embedded the whole thing in a document and ran it on an office suite with no FreeHSQL installed.dreamquartz wrote:PS: what about the LO 5.4.2.2 issue?
The error occurs when moving to LO 5.4.2.2 from LO 5.4.1.2.
Dream
LO 7.x, HSQLDB 2.7.x & Ubuntu 22.04 LTS.
Re: Free HSQLDB 0.3.7 problem LO 5.4.2.2
If the dialog library exists, then it is a bug and should be reported to the LO issue tracker.
Since the AutoInstall module does not depend on the dialog library, it can be used to make your database packages with HSQL2 portable.
Since the AutoInstall module does not depend on the dialog library, it can be used to make your database packages with HSQL2 portable.
Edit: I just updated to the latest 5.4.2.2 and can not reproduce the problem. You should simply re-install the FreeHSQL package. |
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 881
- Joined: Mon May 30, 2011 4:02 am
Re: Free HSQLDB 0.3.7 problem LO 5.4.2.2
Did you check with Ubuntu 16.04 and/or Widows 7 Pro?Villeroy wrote:If the dialog library exists, then it is a bug and should be reported to the LO issue tracker.
Since the AutoInstall module does not depend on the dialog library, it can be used to make your database packages with HSQL2 portable.
Edit: I just updated to the latest 5.4.2.2 and can not reproduce the problem. You should simply re-install the FreeHSQL package.
I tried it with Ubuntu, but still same problem.
Dream
LO 7.x, HSQLDB 2.7.x & Ubuntu 22.04 LTS.
Re: Free HSQLDB 0.3.7 problem LO 5.4.2.2
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 881
- Joined: Mon May 30, 2011 4:02 am
Re: Free HSQLDB 0.3.7 problem LO 5.4.2.2
Had to remove all, and re-install from scratch, but it worked.Villeroy wrote:
Dream
LO 7.x, HSQLDB 2.7.x & Ubuntu 22.04 LTS.
-
- Posts: 881
- Joined: Mon May 30, 2011 4:02 am
Re: Free HSQLDB 0.3.7 problem LO 5.4.2.2
dreamquartz wrote:Hi Villeroy,
It appears that every time a new LO is published the changes are such that your macro 'Free HSQLDB' has a problem.
Attached you will find the print screens.
I also have a question.
I would like to make 'Free HSQLBD' part of the database in stead of part of LO. With other words make it portable. Is that possible?
Dream
LO 7.x, HSQLDB 2.7.x & Ubuntu 22.04 LTS.
Re: [SOLVED] Free HSQLDB 0.3.7 problem LO 5.4.2.2
Notice that you actually move objects when dragging them around in the organizer window. Use Ctrl+Drag&Drop in order to copy objects.
Select the [Modules] tab and drag the 2 modules "AutoInstall" and "Helpers" from My_Macros>FreeHSQLDB and drop them into your document while holding the Ctrl+Key.
On the [Libraries] tab you can easily import the whole FreeHSQLDB Basic library into your document. Choose your document from the list box, click the [Import...] button and point either to a FreeHSQLDB package file, to a Basic file in the folder where FreeHSQLDB is installed or point to any other document having lib FreeHSQLDB embedded already. The module "FreeHSQLDB" won't be functional when embedded in a database document, so you may delete that if you bother. You don't need to import the dialog library because that depends on module "FreeHSQLDB".
Select the [Modules] tab and drag the 2 modules "AutoInstall" and "Helpers" from My_Macros>FreeHSQLDB and drop them into your document while holding the Ctrl+Key.
On the [Libraries] tab you can easily import the whole FreeHSQLDB Basic library into your document. Choose your document from the list box, click the [Import...] button and point either to a FreeHSQLDB package file, to a Basic file in the folder where FreeHSQLDB is installed or point to any other document having lib FreeHSQLDB embedded already. The module "FreeHSQLDB" won't be functional when embedded in a database document, so you may delete that if you bother. You don't need to import the dialog library because that depends on module "FreeHSQLDB".
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 881
- Joined: Mon May 30, 2011 4:02 am
Re: [SOLVED] Free HSQLDB 0.3.7 problem LO 5.4.2.2
I still did not embed it into the database.Villeroy wrote:Notice that you actually move objects when dragging them around in the organizer window. Use Ctrl+Drag&Drop in order to copy objects.
Select the [Modules] tab and drag the 2 modules "AutoInstall" and "Helpers" from My_Macros>FreeHSQLDB and drop them into your document while holding the Ctrl+Key.
On the [Libraries] tab you can easily import the whole FreeHSQLDB Basic library into your document. Choose your document from the list box, click the [Import...] button and point either to a FreeHSQLDB package file, to a Basic file in the folder where FreeHSQLDB is installed or point to any other document having lib FreeHSQLDB embedded already. The module "FreeHSQLDB" won't be functional when embedded in a database document, so you may delete that if you bother. You don't need to import the dialog library because that depends on module "FreeHSQLDB".
I am still working on it. It was the normal extension install that is/was affected by the latest LO.
Dream
LO 7.x, HSQLDB 2.7.x & Ubuntu 22.04 LTS.