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
2
votes
1 answer

Open a form in Libreoffice/Openoffice Base with a specific filter/query

I am creating a Libreoffice Base with multi forms. Form1 is linked to "Projects" table and each Project has multiple tasks, I can display the tasks as sub form within the same Form1, however, each project has many tasks and each task also has sub…
Fahad Alduraibi
  • 372
  • 6
  • 17
2
votes
3 answers

Libre Office Base; Opens reports in read-only

LibreOffice Base opens reports automatically in read-only mode. I've looked everywhere to find how to make sure it doesn't opens reports in read-only mode. Does anyone knows how to make sure that LibreOffice Base won't open reports in read-only…
M Zeinstra
  • 1,931
  • 4
  • 17
  • 46
2
votes
2 answers

LibreOffice Base; Tab order from mainform to subform

I have a form with a mainform and a subform. When the user is in the textbox, which is the closest to the subform, and the user press Tab, it has to jump into the subform, but it doesn't. It jumps to the textbox AFTER the subform. When the user is…
M Zeinstra
  • 1,931
  • 4
  • 17
  • 46
2
votes
1 answer

Replacing numeric foreign key with dropdown in Libreoffice Base

I'm building a form for entering credit/debit transactions, so I have two tables in PostgreSQL accounts id INTEGER PRIMARY KEY name VARCHAR(128) ledger id INTEGER PRIMARY KEY credit INTEGER NOT NULL REFERENCES…
Simon Richter
  • 28,572
  • 1
  • 42
  • 64
2
votes
1 answer

sql works in libreoffice base but not libre basic

I have a classic question about getting the latest record from a table. Here is the statement: SELECT t1.Item, t1.Price, t1.ODate FROM Order AS t1 JOIN ( (SELECT Item, Price, Max(ODate) As MaxDate FROM Order GROUP BY Item ) As t2…
user2301156
  • 21
  • 1
1
vote
2 answers

Count days since 3rd event from today

I have a table Events in LibreOffice Base with a Firebird database (version 3.0.8) that records how many times an event occurs. Example below: Date EventCount 22-04-01 15 22-09-30 10 22-10-01 1 22-10-04 1 I would like to create a…
hiigaran
  • 285
  • 1
  • 10
1
vote
1 answer

HSQLDB to Firebird migration subtracted one day from all date values in tables

Using Libreoffice Base and was prompted to migrate to Firebird from HSQLDB. I had read up about this bug and ensured I had a backup of the original database before proceeding with the migration. It seems the date bug was the only issue with the…
hiigaran
  • 285
  • 1
  • 10
1
vote
2 answers

Difference between two dates in HSQLDB

Got a database in Libreoffice Base using HSQLDB, in which table Expirations has columns Item and Expiry (date value). I would like to run a query that counts the number of days between ExpiryDate and the current date, outputting Item and Days…
hiigaran
  • 285
  • 1
  • 10
1
vote
0 answers

How to restore standard menu bar (File, Edit, View, Insert, Format, etc.) in Libreoffice

libreoffice-6.0.7 on Ubuntu Bionic After purging and reinstalling what I thought was a corrupted version of LibreOffice, it seems that the "Main Menu" of LibreOffice has been deprecated. What I see now are just graphical toolbars of what looks…
user3512967
  • 181
  • 1
  • 3
1
vote
1 answer

how to connect to a postgresql database using libre office base?

I think it surpringly difficult to find some clarity on how to connect to a postgresql db using libre office base... Is it one of the name in the drop down menu? Or do i need to install a plugin ?
jim jarnac
  • 4,804
  • 11
  • 51
  • 88
1
vote
1 answer

LOBase HSQL avoid having to put table and field names in quote marks

using LO Base with a local HSQL database file. What I want to do: copy and paste my existing (and in some cases very long) queries, which are of the form: SELECT table1.field1, table2.field2 FROM table1, table2 WHERE table1.id=table2.id what I am…
tornadof3
  • 234
  • 1
  • 8
1
vote
1 answer

LibreOffice Base form: filling table or grid control not bound to data source

I have a LibreOffice Base DB with a form and a table control on it. There is a macro that gets some data to put in the table. The table is not bound to a data source and it has 1 column "id". I try the following code to add a row to empty…
iyugov
  • 13
  • 4
1
vote
1 answer

How to align a Paragraph centre vertically

I have a small paragraph in a page, which I want to align centre horizontally as well as vertically. Aligning centre horizontally is quite straightforward, however I am struggling to find a way to centre that Paragraph vertically in the page. Is…
Bogaso
  • 2,838
  • 3
  • 24
  • 54
1
vote
1 answer

Problem running embedded firebird sql query in LibreOffice

I am trying to run the following Firebird SQL query in LibreOffice, which has embedded Firebird: SELECT RDB$GET_CONTEXT('SYSTEM', 'ENGINE_VERSION') AS "VERSION" FROM "RDB$DATABASE"; I get the message Syntax error in SQL statement. Can anyone tell…
Z T Minhas
  • 37
  • 6
1
vote
1 answer

PostgreSQL triggers with LibreOffice Base front-end

I have the following trigger function & trigger in PostgreSQL 12.1: create or replace function constraint_for_present() returns trigger as $$ BEGIN if new.present_status = 'viewing' and new.name not in (select viewable_item from…
libcub
  • 15
  • 5
1
2
3
…
11 12