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

Modifying table entries from LibreOffice Base, possible?

I've successfully connected LibreOffice Base with MySQL data base server. I've tested if I modify my table from host (free hosting service on internet) then the changes are reflected when refreshing the table object in LO Base. But my question is,…
JoeCoolman
  • 512
  • 3
  • 8
  • 27
1
vote
1 answer

Unable to "Create Report in Design View" in LibreOffice Base

I am unable to create a report in design view. When I click on this option nothing happens. The "Use Wizard to Create Report" option works fine as do all other options. I am using Linux Mint 17.2. I tried a profile reset without success.
user1897830
  • 443
  • 1
  • 3
  • 10
1
vote
1 answer

Unable to connect the LibreOffice on port 2002?

I am using the docvert 5.1 for convert .doc to html.When i run the "Tests (run all)" during I am getting the error message under the following parts: " ✘Unable to run tests due to exception. Failed to connect to LibreOffice on port 2002. Connector…
Karthick
  • 55
  • 8
1
vote
1 answer

Advice to join LibreOffice Base Table with a MySQL Table

My situation is the following: There are two databases in two different offices linked together by the corporate network. On of the databases is MySQL, which holds data that can change, but the field types never do. This is standard information for…
Dycius
  • 19
  • 4
1
vote
1 answer

LibreOffice Base subform displays unrelated records

I would like help solving a problem with a LibreOffice Base subform. I think the subform should be displaying only the records that are related to the record displayed in the parent form. But the subform is actually displaying every record in its…
MetaEd
  • 3,753
  • 1
  • 28
  • 30
1
vote
2 answers

How to perform operations on dates in queries?

I'd like to add 100 days to a field in a query: SELECT DATE_ADD("date" + INTERVAL '100' DAY) FROM "history"; or whatever… but it doesn't work with the default HSQLDB frontend… Any workaround ?
Bogey Jammer
  • 638
  • 2
  • 8
  • 23
1
vote
0 answers

LibreOffice Base Read read input, display from 2 different tables

So basically I have 2 tables called Product and Category. The Product has the following fields : ID integer, Name varchar(50), Notes varchar(200), Category integer The Category has the following fields : ID integer, Name varchar(50) I have to…
Davlog
  • 2,162
  • 8
  • 36
  • 60
1
vote
2 answers

How do I refresh all tables in a form? LibreOffice Base

I have 3 tables in a single form, they use SQL queries to select the data. I need to refresh them somehow, but nothing works. E.g. this doesn't work at all: oBaseContext = CreateUnoService("com.sun.star.sdb.DatabaseContext") oDataSource =…
Dalius
  • 726
  • 1
  • 8
  • 19
1
vote
1 answer

Semi-hierarchical SQL query with multiple tables and possible outer joins

I have products. Each product is made up of items and assemblies. Assemblies themselves can be made up of items too. So it's a hierarchy but limited in depth. What I would like to do is list products with the items and assemblies it contains, plus…
The Axe
  • 11
  • 2
1
vote
2 answers

LibreOffice Base - query - merge two rows

I'm learning LibreOffice Base (3.6.2). Unfortunatly the doc is pretty poor. The DB is a ".odb" file format. Here's a simple multi-table query: I'd like to merge the field "refLogiciel.name" and "tblPosteLogiciel.version" in one field. Thank you!
Sirber
  • 3,358
  • 5
  • 25
  • 32
1
vote
1 answer

setting java classpath for Libre Office Base in Fedora 16

using Fedora 16 OS. i want to use Libre Office Base to connect to MySQL. when i set up the JDBC connection, it asks me for the driver, however, it cannot be loaded (because it doesn't see it in the classpath). does anybody know how to set the…
amphibient
  • 29,770
  • 54
  • 146
  • 240
1
vote
1 answer

How to make LibreOffice Base reconnect to a database

I am using LibreOffice Base as a generic database client. Sometimes it loses its connection to some database. Is there a way to reconnect it? I mean, a way other than closing and reopening Base?
brandizzi
  • 26,083
  • 8
  • 103
  • 158
0
votes
1 answer

What is a simple way to auto populate field in a form, from a DB in Libre Base?

I am creating an Acquisition Management System for a Library in LibreBase (v7.5.4), thus far, I am at the following: A table called BooksDB containing the fields Accession No (NUMERIC type) (also Primary Key) Title(VARCHAR type) Other information,…
Keshav
  • 21
  • 1
  • 2
0
votes
0 answers

How to limit the suggestions in a list box in LibreOffice Base to unselected items only

I'm trying to filter the selection in a list box in LibreOffice Base so that if an item (from a separate table) has already been chosen, it won't be available to be selected again. As for how my database is designed, I have a main table and multiple…
Kumpel Gras
  • 1
0
votes
0 answers

How to change field name for query in Libreoffice Base?

I successfully created and ran a query for average salary of employees that were hired after 2008 and employees that hold salesperson title in Libreoffice Base. It is like Microsoft Access. However, I am unsure and unable to change the field name of…
ijtnsizziyjhzycguc
  • 1
  • 1
1 2 3
…
11 12