User community support forum for Apache OpenOffice, LibreOffice and all the OpenOffice.org derivatives
https://forum.openoffice.org/en/forum/
It does: http://www.hsqldb.org/doc/1.8/guide/ch0 ... ct-sectionmgroenescheij wrote:The build in database doesn't support a UNION select.
Code: Select all
SELECT "Number" FROM "Table1"
UNION ALL SELECT
SUM( "Number" ) AS "sum" FROM "Table1"Absolutely!mgroenescheij wrote:I strongly suggest that you install an external database e.g. MySQL
Well, lets not misconstue the reality of the situation. The default "embedded database" document-type has severe "disadvantages" due to bugs in Base. But you can connect to the bundled HSQLDB 1.8 engine in much the same way as you would connect to a MySQL server -- for equal reliability. The only difference is the MySQL server is far more difficult to setup and use on a daily basis than HSQLDB with Base -- perhaps specifically in single-user mode using a Base template which automatically creates an HSQLDB 2.3.x database through Base. In general, MySQL has no advantage over HSQLDB serving less than 100 concurrent users through a Base front-end. In fact, there's only disadvantages with MySQL relative to typical Base environments on every point of comparison including: speed, database portability, ease of setup, daily server admin, SQL depth-of-features and standardization, etc.mgroenescheij wrote:I strongly suggest that you install an external database e.g. MySQL
A build in database has disadvantages e.g. if your report crashes you lose also the database and your only able to update from within that document.
My sincere apologies. I was being over-sensitive in the defense of Base users who would simply give-up on Base if a full-blown RDBMS server like MySQL became necessary for reliable or full-featured database access.mgroenescheij wrote:The discussion was embedded or external.
