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

Error in Querying Concatenation of 2 fields in LibreOffice Base SQL

My apologies for wrong terminilogies, I am not actually a programmer, just a Base user confronted with a problem. I'm having trouble querying a column which is supposed to be a concatenation of two fields of two separate tables. I'm using…
Kevin CA
  • 25
  • 1
  • 7
0
votes
1 answer

how to make the user\password required for Base postgresql connection

I'm building an entry form frontend to postgresql using libreoffice 4.0 the first time i open it it will ask me for user name and password, if they were correct it won't ask for it again the problem is it won't ask for it again even if i close the…
Ali
  • 448
  • 6
  • 25
0
votes
1 answer

Simulate GROUP_CONCAT function in HSQLDB versions < 2?

LO/OOO Base doesn't come with an HSQLDB version > 2 which means there is no GROUP_CONCAT function. Is there a way to simulate this function in HSQLDB versions < 2? Here's an example for the columns name and value before the function is…
officebuddy
  • 1
  • 1
0
votes
1 answer

Relationships and forms in Libreoffice Base

I'm auditing some servers and I have a table called "Servers" with a few fields. One of these is a field called "users" I have another table called "users" which holds information on each user. Of course, there are many "root" users (one for each…
Ivy
  • 3,393
  • 11
  • 33
  • 46
-1
votes
1 answer

How to get target from LibreOffice WrappedTargetException?

This is about automation of LO Base using Python macros. Please see this question in the LO forum posed by me yesterday. As you can see, from the link in my second post, it is trivial to open a form on the OpenDocument event, i.e. when the file is…
mike rodent
  • 14,126
  • 11
  • 103
  • 157
-1
votes
1 answer

How would I set focus in a LibreOffice macro (for use in a Base form)? Or set up a "Position-To" field that DOESN'T filter?

In a LibreOffice Base form, I have a button set to call .uno:RecSearch, in order to bring up the record search dialog. The problem with that is that if no field in the form has focus, the record search dialog comes up with the third of seven date…
hbquikcomjamesl
  • 111
  • 11
-1
votes
1 answer

I need a query to do something specific

i have this situation: TABLE ONE: Code Quantity 1 1000 2 1222 TABLE TWO: Code Data 1 bla bla 2 yadda yadda i need to put the quantity column in the table 2, using "CODE" as key… Anyone who could help me with this query?…
Francesco M
  • 69
  • 2
  • 3
-1
votes
1 answer

How can I summarize in each row all the above rows?

Is it possible to get sum of all the above rows in each row? Example: Rows | Count 1. | 20 2. | 30 3. | 10 4. | 25 And I want to take the follow result Rows | TotalCount 1 | 20 (20) 2 | 50 (20+30) 3 | 60 (20+30+10) 4 | 85…
Yannis
  • 9
  • 1
-1
votes
1 answer

LibreOffice/Excel Table Calculation Formula

I have three Columns in one sheet. Col1 Have Combination Of Col2 Values, I need to replace Col1 Value as equal Of COl2 = col3 Value. Is there Any Formula to do this in LibreOffice Calculation. Actual Table: Col1 | col2 | Col3 A | A | X …
Kamal kannan
  • 253
  • 3
  • 17
-1
votes
2 answers

My queries aren't working

Hey everyone I'm trying to do these 2 queries but I can't seem to get them right. I'm not sure what I'm doing wrong, can anyone help me? a. List all results for all students from the Faculty of Business. The query result will display SID, Name,…
s.chitti
  • 21
  • 6
-2
votes
2 answers

Why is the command not working

What is wrong with that command I'm trying to use? Why is it not working? I could rage endlessly with hSQL... in combination with openoffice_base (because my employer is a cheap son of a) one day it'll kill me.. Explanation: Table Suppliers ->…
user6718396
  • 1
-3
votes
3 answers

How do I add days to a date in a query?

I'm using libreoffice base with an embedded HSQLDB database. I have a query extracting a single line from a table. SELECT "ID", "Name", "Date" FROM "Table" WHERE "ID" = ? I would like to add a field "Due Date" that displays a date 30 days after…
18107
  • 714
  • 5
  • 11
1 2 3
…
11
12