Why "Access is denied: ROW_NUMBER( ..."?

[SonomaCharles]

@Villeroy this is SUPER helpful. Thank you again. I have read through the linked post on the AOO forum. I have downloaded HyperSQL 2.4.1 and understand how to set up the folders.

I am only unclear on one thing:

Python needs to be enabled which is the case if there is a menu entry Tools>Macros>Organize>Python. Ubuntu Linux installs LibreOffice without the Python bridge. Add package “libreoffice-script-provider-py”. Under Windows you have to re-run the installer and add this package if it had been deselected.

I have Python macro support. I see 8 macros under Tools/Macros/Organize Macors/Python.

I don’t see ExtractHSQL. I tried re-running the LO installer but there are no “options” other than a choice of installation folder. I don’t see any option to select or de-select any particular components. How do I get ExtactcHSQL or how do I get it installed?

|OS Name|Microsoft Windows 11 Pro|
|Version|10.0.26200 Build 26200|

[Villeroy]

Download the attachment from Apache OpenOffice Community Forum - [Python] Macro to extract and reconnect embedded HSQLDB - (View topic)
It’s a Writer document with a push button installing the macro.

Within your profile folder, the path to the script is Scripts/python/pyDBA/ExtractHSQL.py

[cpb]

@SonomaCharles,
it’s really not that difficult to calculate row_number using embedded HSQL, it is however impossible to offer specific guidance without meaningful info, a sample database would be most helpful.
.
download “Quaresma3.odb” from here
.
take a look at the query “qSetup” which shows how to calculate the row number, it’s similar to the sql posted by RobertG but also has the ability to handle duplicates.

[SonomaCharles]

@Villeroy I see the download. Thank you. It’s easy when you know where to look for it.

[SonomaCharles]

@cpb thanks. I will get to that. The first problem on my plate is getting from embedded HSQLDB 1.8 to external HSQLDB 2.x.