Stack Overflow
Stack Overflow

Questions tagged [libreoffice-base]

Libreoffice Base is a standalone database/form application which allows you to manage data organized into tables.

Libreoffice Base is a standalone database/form application which allows you to manage data organized into tables.

The official documentation can be found on the Libreoffice documentation page

177 questions
1
vote
1 answer

Libreoffice Base - how to call a control event from a macro?

Question: I need to manually call an object listener event (e.g. key pressed) to trigger a function. I used to do it in Access but haven't found the documentation for it in LibreOffice Base. Context: Having retired from software development 7 years…
Hippy Steve
  • 111
  • 1
  • 2
1
vote
2 answers

Not in aggregate function or group by clause: org.hsqldb.Expression@59bcb2b6 in statement

I'm trying to group SUM(OrderDetails.Quantity) but keep getting the error Not in aggregate function or group by clause: org.hsqldb.Expression@59bcb2b6 in statement but since I already have an GROUP BY part I don't know what I'm missing SQL…
DontEatMyCookies
  • 188
  • 1
  • 12
1
vote
0 answers

Trouble making 4 linked tables SQL query work

I have 4 tables: Customer (CustomerID(PK), FirstName, LastName) Order (OrderID(PK), CustomerID(FK)) Purchase (OrderID(FK), GameID(FK), Quantity) Games (GameID(PK), RetailPrice) I would like to list the names of all customers whose orders total…
user236529
  • 115
  • 1
  • 8
1
vote
0 answers

Why does LibreOffice base, Microsoft Excel and Tableau require unnecessary permission to query table data from bigquery?

I have a BigQuery instance and I have shared a view with a service account. This service account has the "bigQuery.User" role. I setup Simba ODBC drivers on my Ubuntu machine, installed Libreoffice base on it and also modified the odbc.ini file to…
Haris Muzaffar
  • 404
  • 6
  • 17
1
vote
0 answers

How to set up "DEGREES" "MINUTES" "SECONDS" in a table of a database?

I am going crazy to set up DEGREES MINUTES and SECONDS in a table of LibreOffice Base for Longitude and Latitude. When I set TIME [HH].MM.SS in a column of cells of LibreOffice Calc and then I compile starting from value 180.00.00 and incrementing…
Luca DEL PARTITA
  • 41
  • 2
1
vote
2 answers

How to INSERT INTO in ONE TABLE from MULTIPLE TABLES?

I will make you an example with GRADES MINUTES and SECONDS on three different tables. T_GRADES ID_GRADE - Primary Key - Autoincrement GRADE - Numeric (all numbers from 0 to 359) T_MINUTES ID_MINUTE - Primary Key - Autoincrement MINUTE - Numeric…
Luca DEL PARTITA
  • 41
  • 2
1
vote
0 answers

How to connect to Libreoffice Base OR MS-Access database from Angular based Electron app?

I am developing an ERP desktop app in Electron using Angular We decided to use Libreoffice base OR Ms-access to store the user stocks and transactions The base / ms-access file will be bundled along with electron Now my problem is I want to…
RagAnt
  • 1,064
  • 2
  • 17
  • 35
1
vote
0 answers

Relational database tool, which can display PDF blobs

I would like to collect my orders in a very simple relational database with some PDFs inside binary a field. I would like to easily browse the PDFs without building a frontend. There are many SQL admin tools available which are perfect for browsing…
Johu
  • 626
  • 7
  • 15
1
vote
2 answers

What is the simplest way to do "SELECT TOP 5" for multiple parameters?

I'm trying to build a new database in LibreOffice Base / HSQLDB which supposedly supports standard SQL, but probably not quite as widely as SQL-server or Oracle. I've got a table of scores, where the participant is a member of one of a list of…
MikeB
  • 580
  • 3
  • 18
1
vote
0 answers

posgresql-libreoffice(base): how to connect heroku database to libreoffice base

I want to use Heroku PostgreSQL database through my LibreOffice Base, I'm a newbie at this, can't find any good articles online, Is it even possible, if yes, how? My goal is to administer my local database online.
R. Gurung
  • 1,356
  • 1
  • 14
  • 34
1
vote
0 answers

missing-FROM clause Error in LibreOffice Base Listbox

I'm using LibreOffice Base 5.3.4.2 as a front-end for a postgres database. In postgres, I have the following tables: lu_ss_unit_types (lookup table that stores different unit types) ss_unit_mix (uses fkey from lu_ss_unit_types) ss_rent_surveys (uses…
NDogg
  • 11
  • 4
1
vote
1 answer

Creating a text/csv file from LibreOffice

I am in the process of starting a project and i want to understand the best way to automate the creation of a text/CSV file containing the result of a request. And each time the database is updated, i want that file to be updated too. I'm using…
Rania Saidi
  • 11
  • 1
1
vote
0 answers

Best way to run Macro on LibreOffice or OpenOffice SubForm "Fill parameters" Event

I try for more than a week to fill out a SQL query parameter by running a macro on the "Fill Parameters" event in the subform by searching for a method to fill the parameter under the Parameters object with MRI without success. Searches for guides…
Sagi Nadav
  • 295
  • 1
  • 3
  • 14
1
vote
2 answers

HSQLDB Trigger update for LibreOffice Base

I am trying to create a BEFORE UPDATE trigger to stop the HSQLDB update and throw an exception, if the user enters date left input earlier than date in. I followed the example given in the link http://hsqldb.org/doc/guide/triggers-chapt.html But…
user614454
  • 123
  • 2
  • 13
1
vote
1 answer

Editing possibility in queries

LibreOffice 5.1.6.2 I have saved some queryes and I'd like to allow users to use them directly (without any reports). Reason: there are filters thare, they are convenient. My users are sophisticated ones, so queries are ok. The problem is a…
Michael
  • 4,273
  • 3
  • 40
  • 69
1 2
3
…
11 12