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
0 answers

libreoffice base left join deletes row

I have the following query in Base: SELECT field_name1, field_name2, .,.,. FROM table_a INNER JOIN table_b ON table_a.field_name1 = table_b.field_name1 INNER JOIN table_c ON table_a.field_name2 =…
user1897830
  • 443
  • 1
  • 3
  • 10
0
votes
1 answer

LibreOffice Base - Display calculated column

I have created a query in Base which has a calculated column (modified sql SELECT statement) based on another column in the query. The problem is when I enter a value for the column on which the calculated column is based and then tab to the next…
user1897830
  • 443
  • 1
  • 3
  • 10
0
votes
0 answers

Using the UCANACCESS_HOME system property with LibreOffice Base and UCanAccess

I am trying to use LibreOfffice Base to access an MS Acccess database using UCanAccessv3.0.1 on Lubuntu. Everything is fine until I get an error message about the UNCANACCESS_HOME system variable. In spite of correctly entering the path, I get a…
Mike Sullivan
  • 1
  • 1
0
votes
1 answer

Several boolean fields or one text field in database?

I'm just getting my feet wet in databases and in creating a database I came to the realization that there are instances where what could be a text field could also be several Boolean fields. To give a concrete example: I'm creating a database that…
IllWills
  • 1
  • 1
0
votes
1 answer

How can I fill the fields of a table in LibreOffice Base automatically?

I have a database which contains a table of cellphones. Let's say that every cellphone has 10 fields. In order to fill or modify the table I will have several forms available for the user. However, I don't want the user to modify all 10 fields every…
stavros
  • 23
  • 6
0
votes
0 answers

Making form that handles relationships in base

I have a simple database (made just for practice) with a number of tables. It's supposed to be a "Library usage database", with tables for books, lenders, cities etc. For instance, the table "Lenders" is a table with..well.. people loaning books…
McWolfe
  • 188
  • 1
  • 7
0
votes
3 answers

LibreOffice Error "1: Unexpected token: UNQUE in statement"

I ran this SQL command CREATE TABLE TEST( KEY char(10) UNIQUE NOT NULL, PRIMARY KEY(KEY) ); and it gave me this error: 2: Unexpected token: UNIQUE in statement [CREATE TABLE TEST( KEY char(10) UNIQUE] I'm just trying to create a simple…
srakrn
  • 352
  • 2
  • 16
0
votes
1 answer

insert into select with different data types

I am trying to copy data from table1 to table2 in libreoffice base using a query like: INSERT INTO "table1" ("column1", "column2", ...) SELECT "column3", "column4", ... FROM "table2"; column4 is a VARCHAR with value like '5/5/2015'. My problem is…
djamnazi
  • 1
  • 1
  • 1
0
votes
1 answer

SQL Insert from a select and a math operation

I am using LibreOffice base because I need to use the same database in Windows and in OSX. I have a table with a hundreds of CLIENT_ID as Primary Key and CLIENT_NAME as field. The primary key has a length of 6 chars: CLxxxx I'd like to be able to…
nico9T
  • 2,496
  • 2
  • 26
  • 44
0
votes
3 answers

Getting document path in Basic in LibreOffice macro

I know that this question has already been answered but the given solution doesn't work for me. The given solution is: Dim oDoc As Object Dim Path$ oDoc = ThisComponent Path$ = oDoc.getURL() Actually this returns an empty string ("") for me. Is…
dom_beau
  • 2,437
  • 3
  • 30
  • 59
0
votes
1 answer

LOBase HSQL subquery of subgroup data

I have a database of my bike rides that I am using to learn SQL using Libreoffice Base and HSQL. The database consists of a table with columns for: Index, Date, Bike, Miles. What I would like to do is create a column with sums of the bike rides for…
user50506
  • 181
  • 1
  • 7
0
votes
1 answer

Calculate delta between chronological records (LibreOffice Base)

I'm fairly new to SQL and this problem I am facing I cannot solve with my current knowledge(it's pretty impossible to become SQL expert in just few days). Consider that I have a following simple Table: ID Date Counter 1 03/25/14 291.5 2…
G.Wolf
  • 35
  • 6
0
votes
1 answer

Full Dataset Export blank dataset

I have a database in libreoffice Base (Debian) which I need to export the tables as an xml file. I have created a piece of Eclipse Java code which is as follows: package NewDB; import java.io.FileOutputStream; import java.sql.Connection; import…
xcc140
  • 13
  • 1
  • 4
0
votes
1 answer

Export Iibre office database table to text file or csv file

I have a Libre Office database table that I want to export or save as a .csv file. Is there any way to do this? I have been searching for a long time. I can write a very little bit in Java but would need some code suggestion in that case. Thank you!
user2717693
  • 33
  • 1
  • 1
  • 5
0
votes
1 answer

Checkbox Reference Value in LibreOffice Base Form

I want to make a checkbox in the form editor of Base to fill boolean values (in this case, "Male", and "Female") in my table. I am currently stuck in the checkbox control window's "Data" tab because I do not know what to put in the fields "Reference…
Kevin CA
  • 25
  • 1
  • 7
1 2 3
…
11
12