Thanks for the reply.
Since the question of 32 or 64 bit also concerns the version of Java to make Base work, can you clarify whether it is also possible in Sonoma and M1 processor?
So far I haven't succeeded. Thank you.

https://forum.openoffice.org/en/forum/viewtopic.php?p=545753#p545753 Q45: Is OpenOffice for MacOS a 32-bit or 64-bit application? A45: The last 32-bit version for MacOS was AOO 4.0.1. AOO 4.1.0 for MacOS (2014) and later are 64-bit applications. MacOS 10.15 (2019) and above require 64-bit applicatio...

The functioning of the forum today is truly stressful

Thanks for your answer.

Forum site very slow for a few days. Has anyone noticed this?
Thank you.

Thanks @RPG, yours is the right solution, congratulations, bravo!
Anyway, thanks to everyone for testing and for your suggestions.

I installed the only version available for M1 mac, both Jdk and Jre, but always with the same error message. That seems 64 bit Java. The only available version of the AOO is 32 bit (for Windows) . Maybe you must change to LibreOffice(?) That has 32 and 64 bit versions. Thanks, as already said in my...

Zizi64 wrote: ↑Fri Oct 27, 2023 1:11 pm Do you have 32 or 64 bit Java?

Try the Temurin Java. That is really free for everyone (and it works for me on Windows).

I installed the only version available for M1 mac, both Jdk and Jre, but always with the same error message.

floris v wrote: ↑Fri Oct 27, 2023 1:11 pm It looks okay to me. You told AOO to use a JRE, you get a list of available JREs and selected one, and with that done and after restarting AOO, it worked for me every time. Do you get an error message?

If I try to open a Base table it tells me that that Jre version is defective.

Thanks for your reply, my query behaves as you said. But is this normal, is there a function that the query design doesn't support? CAST? DATEDIFF? MOD? I had already used them in the past but I didn't realize that they caused problems in design mode. Update: it seems that query design doesn't suppo...

Hi everyone, I had to change my old iMac for a new iMac M1 with Sonoma mac OS14. The installation of Java for LibreOffice was successful but not for OpenOffice, as seen in the figure. How can I do? Please don't make me read the tutorial Mac FAQ https://forum.openoffice.org/en/forum/viewtopic.php?f=7...

Hello everyone, the query of this embedded HSQLDB database works if executed directly or if executed from the Edit window in SQL view (F5). If executed instead from the Edit window (F5) it gives me syntax error. I don't understand why, can you help me? My OS and LibreOffice versions are the ones in ...

Ciao, that limitation is only apparent, the asterisk indicates that there are other records beyond 52.
If you hold down the left mouse button on the Next record icon, the number that appears will progressively update.
In other words: everything is fine.

keme wrote: ↑Wed May 31, 2023 11:57 am I guess it is not supported with AOO Base "embedded" (old HSQLDB version) ...

COALESCE is supported in the embedded HSQLDB 1.8.

Today I quizzed him on a more complex Calc sheet, both with and without macros. He made me make a large number of attempts but was unable to resolve.
Volunteers of the Forum, you can still hope to remain in your post

A while ago I asked him the question again, the code is slightly different, the cells have been moved horizontally, but the macro works. It almost seems that he has studied during the past hours :roll: . answer : Write a Basic macro for Calc that calculates the sum of two cells question : Here is a ...

Hello everyone, intrigued by the news on Chatgpt, I wanted to try it. After asking trivial questions, I had him write a macro: question : Write a Basic Calc macro that calculates the sum of two cells answer : Here is a macro that adds the contents of cells A1 and A2 and writes the result into cell A...

Only now do I hear the sad news. I'm sorry, I learned a lot from his posts too. A preier.

In un database embedded come HsqlDBembeddedOOo tutti i file che compongono il database sono nel file odb (in realtà vengono estratti dal file odb durante la connessione al database e poi reintegrati alla chiusura del file odb). Ciò facilita il trasporto del database poiché tutto è contenuto in un u...

L'ultimo aggiornamento di HsqlDBembeddedOOo consente ora l'utilizzo di OpenOffice I confirm, it works also in macOS. L'API di OpenOffice non consente l'aggiornamento del file odb quando è chiuso (a differenza dell'API di LibreOffice) quindi il database viene mantenuto in modalità divisa. Ciò signif...

With OpenOffice 4.1.13, something happens that I don't understand. If I follow the "Create new database" procedure I get the error: The connection to the data source "New database" could not be established. Url: 'sbdc:embedded: hsqldb' cannot be loaded. Please check syntax But if...

I forgot to do that…
Now however Java 11.0.16.1 is installed correctly, but in LibreOffice 7.2.6.2 I get this error installing the Driver extension: My operating system is that of my Firma, rather old ...

Interesting ... but it doesn't work in Mac environment. The Driver is not recognized, both in OpenOffice and in LibreOffice.

Did you use double quotes?

HI, I try your SQL command, it works for me, without errors.

Nice your solution, but @John Riviera wanted 2 columns:

John Riviera wrote: ↑Wed Jul 27, 2022 2:52 pm Esiste un codice per avere, come risposta, 2 colonne, una F, una M, con numeri sotto ?

Sorry I expressed myself badly (my English! ), I meant that a part of the code remains hidden on the right side instead of being all visible.
Is it a problem of my browsers?

deleted Italian names in queries I did like this: Written Query1 SELECT COUNT( "Gender" ) AS "F" FROM "R_GenderF" Written Query2 SELECT COUNT( "Gender" ) AS "M" FROM "R_GenderM" Written Query3 SELECT "Query1"."F", "...

Hi everyone, how do you see the multiline code in this forum? I see it like this in macOS 10.13.6 and Firefox or Safari, but there are three lines:
https://forum.openoffice.org/en/forum/v ... 51#p526751

Try this code: SELECT (SELECT COUNT( "Gender" ) AS "F" FROM "R_GenderF") As "F", (SELECT COUNT( "Gender" ) AS "M" FROM "R_GenderM") AS "M" FROM (SELECT COUNT( "Gender" ) AS "F" FROM "R_GenderF&qu...