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

Token unknown error on DATEDIFF(DAY ...) after Firebird migration

I have the following code made from when my database was HSQLDB: SELECT "Item", DATEDIFF('DAY', CURRENT_DATE, "Expiry") AS "Days Remaining" FROM "Expirations" The date values in the Expiry column are in the YY-MM-DD format. After…
hiigaran
  • 285
  • 1
  • 10
0
votes
1 answer

Tracking finances owed using a database

For years, I have used the humble spreadsheet as a way of keeping track of finances, but as this spreadsheet grew in size, and as I required more types of data analyses, it eventually became clear that a spreadsheet was no longer going to cut it.…
hiigaran
  • 285
  • 1
  • 10
0
votes
0 answers

How to create a copy of a linked database in LibreOffice Base

I have a connection to a Microsoft Access to Libreoffice Base using a JDBC connection. When I save the database in Base it retains the connection. I want to create a copy as a standalone Base database which includes all the imported tables, so that…
Packwood
  • 239
  • 4
  • 13
0
votes
0 answers

Trying to find entries where multiple keywords are present in column (AND not OR)

I'm trying to figure out a way to find an entry or the entries where my keywords (multiple) are present in the category table / category name column . CREATE TABLE entry ( entryid INTEGER PRIMARY KEY, title TEXT NOT NULL, datecreated date NOT…
l1z4rd
  • 1
  • 1
0
votes
0 answers

Is there a faster way of using NOT LIKE for a long list of search terms instead of {AND "Column" NOT LIKE '%word1%'} etc, in an SQL Query?

So I'm trying to exclude a bunch of different entries with specific words from my query and I was wondering if there was a more efficient/faster way of doing this over the method that I am currently using: AND LOWER("Column") NOT LIKE…
Jade8703
  • 1
  • 2
0
votes
1 answer

Primary or unique constraint required on main table: "Orders"

Sorry if the title is unclear. As of right now, I just have a spreadsheet of a bunch of customers and orders. For example, a line in the spreadsheet might look like: A Customer with an ID of 1 with name Sally and address 291 North Street bought item…
divinelemon
  • 1,925
  • 2
  • 23
0
votes
1 answer

libreoffice Text Aggregator

Is it possible to concatenate text from an aggregate function in LibreOffice Base. For example: column1 Column2 Column3 1 Hello 23 2 World 27 The function would then return "Hello, world"
Erik Frandin
  • 25
  • 3
0
votes
1 answer

Can SQL find a lack of a match?

I have three databases: 1.) A database of people, each with a unique number 2.) A database of dates where something happened, each with a unique number 3.) A database of who went to these events, meaning a table with a person number and an event…
user1833028
  • 865
  • 1
  • 9
  • 18
0
votes
1 answer

I'm developing a database with entry data forms in libreoffice Base, how can I hide the background app and show the forms and subforms only?

I don't want users can see the tables, bar menu, etc of main Base app, I need users only can see the forms and subforms to enter data or show reports from search queries at the database. Thanks!
Lord Yasha
  • 1
0
votes
1 answer

Transpose multiple rows into 1 row, multiple columns when not all rows have all columns

I am inheriting some data in an awful format, originally a spreadsheet and turned into an SQL table and I'm using SQL (LibreOffice Base as prototype and then probably MySQL) to query the data. My source data looks…
tornadof3
  • 234
  • 1
  • 8
0
votes
1 answer

Filled field with macro doesn't stock in database

I've made a macro to get information about the user to autofill two fields, name and last name. It works and display the information in the fields. In my form, they are both linked a field in the database. My issue is that when I save my form, the…
samuel potter
  • 189
  • 3
  • 13
0
votes
1 answer

SQL (LibreOfficeBase) How to perform logic function between two columns

I'm attempting to filter a table by the comparison between two columns. For instance, imagine the table Student with column TestPassed and the table Course with the requirement on the test. Given the following view: id.Course id.Student …
Chutlhu
  • 195
  • 2
  • 10
0
votes
1 answer

How to combine calculated fields with the same foreign key?

The title might not be entirely accurate to my problem but I couldn't think of how to word it. I'm using a view to calculate the adjusted unit price of an item after accounting for initial setup costs, so the calculated field looks something like…
aryst0krat
  • 105
  • 1
  • 7
0
votes
1 answer

How to get content from field

I'm totally new to Base. I have different forms but in one named F_STRUCT of them I'm trying to make a macro which will allow the user to autofill another field when he select a zipcode. so the database looks like this. ID_ZIP ZIP CITY 1 …
samuel potter
  • 189
  • 3
  • 13
0
votes
1 answer

Read data from odb database with firebird embedded and connect from C#

So, I'm in way over my head here and been trying this for 8 hours and have gotten zilch Some context: I'm looking into a issue for a friend where I need to convert some data from a homebrew database made in LibreOffice Base backed by some Firebird…
DaVaMa
  • 11
  • 5
1 2 3
…
11 12