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
23
votes
5 answers

LibreOffice: 'com.mysql.jdbc.driver' cannot be loaded

I am trying to connect LibreOffice Base with an MySQL database, in phpMyAdmin, with a JDBC-connection. The first step is to select which database you want to select: The second step is to select which connection: The third step is to select your…
M Zeinstra
  • 1,931
  • 4
  • 17
  • 46
6
votes
2 answers

How to access ODB files in Python 2.7

I want to access an ODB file (made with LibreOffice Base) in Python and extract a table for further use. The ODB contains several tables, one relation design and several forms. Is it possible to achieve this without using any SQL? Edit: Since it…
rypel
  • 4,686
  • 2
  • 25
  • 36
3
votes
1 answer

Two queries work separately. Errors when combined. How do I combine two SELECT statements in Libreoffice Base?

I've reached a point with a spreadsheet where it is no longer viable to keep data in that format. I've created a table in Libreoffice Base with the relevant information and I'm trying to put together some queries. Unfortunately, my attempts to…
hiigaran
  • 285
  • 1
  • 10
3
votes
1 answer

LibreOffice Base can't edit MS Access data

I have a MS Access 2003 database on a Windows 10 PC running WampServer 2.5. I can open it in LibreOffice 5.1 Base. I added a test table with LibreOffice Base, consisting of the following fields: id word The first field (id) is an integer field,…
John Rand
  • 995
  • 2
  • 10
  • 20
3
votes
1 answer

Database hierarchy, aggregation, relations in LibreOffice Base

I am working on a homework project where we design a website for a store, and I have been assigned the database. This is my first database attempt. I am using LibreOffice Base for the design, and cannot find any guides on how to make subtypes. For…
Jallows
  • 185
  • 1
  • 7
2
votes
1 answer

Database size spiralling out of control due to duplicate images

Using Libreoffice Base with Firebird as a financial tracker. Originally had a ledger table, including a column for an image. For each entry, I would add the invoice associated with it. However, multiple rows could have the same invoice, and this is…
hiigaran
  • 285
  • 1
  • 10
2
votes
1 answer

Importing 400k rows in an ODS spreadsheet into LibreOffice Base

I have a ODS Speadsheet that contains just over 400k rows which I want to import into LibreOffice Base as a Table. As a test, I can import 10 rows easily by dragging the sheet to the Table area in Base. If I try and do this with the full spreadsheet…
Packwood
  • 239
  • 4
  • 13
2
votes
2 answers

How to start a Paragraph always in a new page?

Let say I have 3 paragraphs in one page. Now if I add few new sentences in 1st Paragraph, all 2 Paragraphs below the first, will move downwards in a continuous fashion. However I want all these 3 paragraphs will start in a new page. Let say, first…
Bogaso
  • 2,838
  • 3
  • 24
  • 54
2
votes
3 answers

PostgreSQL: INSERT into and get the new ID for usage in LO-BASE

I'd like to add a line to a table: CREATE TABLE actors ( id_act serial NOT NULL, first_name text NOT NULL, last_name text NOT NULL, CONSTRAINT actors_pkey PRIMARY KEY (id_act) ); INSERT INTO actors (first_name, last_name) VALUES…
StOMicha
  • 315
  • 1
  • 3
  • 12
2
votes
0 answers

Is there any way to export/embed LibreOffice Base's forms into HTML pages?

First: I know I am talking about two completely different worlds here. I would like to embed some LibreOffice Base's forms into my HTML pages, possibly keeping CRUD functions. I am requested to extend an existing web app, adding tons of already…
Alex Poca
  • 2,406
  • 4
  • 25
  • 47
2
votes
1 answer

How to add a series of data in a table?

I need to add a series of data from 0 to 1000 in a column of a table in LibreOffice Base and I would like to find a way with a SQL command instead to insert all 1000 one by one. Is it possible to do or not?
Luca DEL PARTITA
  • 41
  • 2
2
votes
0 answers

Libre Base form - selecting and printing multiple records

I created a form in LibreOffice Base and its data is connected to the tables within Base. I also created a button. When I select a record with the form and then click the button, the data gets printed. I'm using a macro which selects a Writer as…
Vladimir Krstic
  • 21
  • 4
2
votes
1 answer

How can I use forms in libreoffice base to add/modify data in a many-to-many relationship?

I am essentially trying to create a glorified contacts list using LibreOffice Base. Many of our contacts have multiple addresses (office, mailing, home), and sometimes multiple people have the same address. I've created a simple contacts table with…
user9058183
  • 21
  • 3
2
votes
1 answer

LibreOffice Base Execute Stored Procedure/Function

I'm busy setting up a odb file with LibreOffice Base to be used with LibreOffice Calc. The odb file is working fine I can create and save regular queries but it is giving an error when I try to execute a Stored Procedure/Function. When using pgAdmin…
TheLovelySausage
  • 3,838
  • 15
  • 56
  • 106
2
votes
1 answer

LibreOffice Base - How to populate listbox values(not sql/table) from code?

I am toying with Base but am stuck on how to set the ListSource of a ListBox with an array of values rather than data from a query. Any help would be appreciated.
reg1965
  • 147
  • 3
  • 8
1
2 3
…
11 12