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

How to decrement Auto column or Field by one using UPDATE SET on LibreOffice Base?

I have a table with auto increment column (ID) and have already filled my table with records. Then, after sometime I noticed that the auto increment (ID) column started from 2 instead of 1. I really wanted the count to start from 1. So, what I want…
ThN
  • 3,235
  • 3
  • 57
  • 115
0
votes
1 answer

Connect to MariaDB with LibreOffice 5.2 (edits are not possible)

I installed MariaDB and phpMyAdmin on my Synology at work and created a database. I was able to create the first fields with LO Base, which means that the JDBC-connector is working. The user hast % as location and I can edit everything from my…
m_for_manu
  • 1
  • 2
0
votes
1 answer

LibreOffice Java package settings vendorData

So I've got a task today, to automatize the proccess of selecting Java package in LibreOffice (when you install new Java version in GPO, you have to select new version of Java manualy in LibreOffice by Tools->Settings->LibreOffice->Advanced). The…
PatrykMilewski
  • 922
  • 8
  • 17
0
votes
0 answers

Associative Table will not take one of the primary keys

I have 2 tables joined with an associative table in PostgreSQL 9.5.3, front end Librebase with a join as follows (pk woid--> fk woid fk UNIQUE_ID--> pk UNIQUE_ID (woid varchar, UNIQUE_ID BigInt(8)). How this works in HSQL is from an entry in the…
MrKingsley
  • 171
  • 1
  • 10
0
votes
1 answer

lookup table in Postgres and libre Base not populating

I have a postgreSQL 9.5 database connected to with LibreBase trying to build a work order tracking app. I am trying to build a lookup filed with drop downs in my form but I get relation does not exist error when I link it to the listbox. It works…
MrKingsley
  • 171
  • 1
  • 10
0
votes
1 answer

Simple python script to get a libreoffice base field and play on vlc

I've banged my head for hours on this one, and I don't understand the LibreOffice macro api well enough to know how to make this work: 1) This script works in python: #!/usr/bin/env python3 import subprocess def…
Trees4theForest
  • 1,267
  • 2
  • 18
  • 48
0
votes
1 answer

Accessing SQL array element from Libreoffice Basic

I have a postgresql database that contains program data. In Libreoffice Calc, I have Basic macros that interact with the postgresql database and uses Calc as the user client. One of the postgresql tables has an array and I can't index into that…
Smith
  • 103
  • 6
0
votes
1 answer

Error message when running UPDATE command in SQL

I am trying to run the UPDATE command in SQL to change the values of certain columns based on a specified ID. UPDATE Table SET variable1=300,variable2=600 WHERE ID=platinum; However, whenever I try to run the query (I am using Libreoffice Base), I…
percy
  • 33
  • 5
0
votes
2 answers

SQL intersection - error in syntax

I am trying search for flights departing from London and Arriving in Paris. The information about the cities are located in the Airport table, while the abbreviations for the departing and arriving airports are located in Flight. Here's my code for…
Sick0ne
  • 23
  • 1
  • 1
  • 4
0
votes
2 answers

LibreOffice Base: open context menu to edit order of columns in a table control

I have a table control. I want to edit the order columns. I right-click on the column header, but the context menu that opens, is the one of the table control itself, but the one for the columns. I also tried already: Keyboard-only edit mode…
mickey
  • 99
  • 1
  • 6
0
votes
1 answer

Base crashing on union sql

I have 29 separate tables of council address data with identical field headers and thousands of entries. I am trying to find an address based on property id that should appear in at least one of the tables. I have been trying to use a union…
Axel Clark
  • 1
0
votes
1 answer

Update HSQL table values based on related table

I have 2 related tables: "Universities"(id, num_courses) and "Courses" (id, university_id). I need University.num_courses to represent a COUNT of courses. I can query data I need: SELECT Universities.id, COUNT(Courses.university_id) as…
I Hafid
  • 373
  • 2
  • 13
0
votes
0 answers

Libreoffice base report's total

I've found a lot of info about how to add "total" row to report, but none of them worked as needed. As for the moment I have a report, made of query and additional query, calculating only totals. the report shows the first query's values as a table.…
Alex Tiger
  • 377
  • 3
  • 22
0
votes
1 answer

Add record with ID, selecting NAME from another table

Can anyone, please, help me with Libreoffice Base form creation? I have the following tables: And I'm trying to add a form to enter new RESOURCES record with the following fields: [RESOURCE_NAME], [CURRENCY_NAME] and [AMOUNT]. But after 10+ tries I…
Alex Tiger
  • 377
  • 3
  • 22
0
votes
1 answer

Base data sheet form will not display calculated Field

I have a Data Sheet form which has a calculated field column. However the field will not display even though it has the correct value. The field in question is "numRisk": Sub Calculate_Risk (Form As Object) Dim OrderPrice, IfDonePrice,…
user1897830
  • 443
  • 1
  • 3
  • 10
1 2 3
…
11 12