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

How to append data to a concatenation, from another table, only if that data is available

I have 2 tables: L0INS (ID_INS, Nume_INS) 1 ANB 2 ENEL 3 DIGI L1AVZ (ID_AVZ, FK_INS, Nume_AVZ) 1 1 APA 2 1 CAN 3 1 HID 4 2 ELE I want to make a query that displays the following: Query1 (ID_INS, CONCAT(Nume_INS, Nume_AVZ) ) 1 ANB, APA 1 ANB, CAN 1…
Dragos Dascalu
  • 15
  • 3
0
votes
1 answer

Can records be copied in libreoffice base

Running version 5.2.2.2 of LibreOffice on linux. I'm evaluating a replacement for using the MS-Access front-end to a Postgres table backend, primarily because Microsoft seems to be itching to EOL Access. I read that LibreOffice Base is a good…
daveg
  • 1,051
  • 11
  • 24
0
votes
0 answers

Adding a file to Libreoffice-writer as OLE and converting the Writer to PDF

I have created a Libre-office Writer and attached Spreadsheet as OLE object using Insert-Object-OLE-object. Now I converted my Writer file to a PDF file for distribution to general recipients. But when I did this, the attached Spreadsheet is not…
Bogaso
  • 2,838
  • 3
  • 24
  • 54
0
votes
1 answer

View Libreoffice Base queries to mysql

I'm trying to create a table with a primary key from Libreoffice Base connected to MariaDB. A standard table with a primary, autogenerated (incrementing I presume) key. But it fails with this message: Error: 1064 You have an error in your SQL…
Leif Neland
  • 1,416
  • 1
  • 17
  • 40
0
votes
1 answer

In LibreOffice, how to connect to Oracle Database using Basic only

I am trying to import Oracle data into my OfficeBase data base (FireBird). My goal is to open a record which connects directly to oracle like this: connect to the oracle database using a proper connection string get to the data with the appropriate…
Z T Minhas
  • 37
  • 6
0
votes
0 answers

LibreOffice calc formula: find the value for a given data based on known data

I have LibreOffice Calc spreadsheet with table that calculates cost for two services. I want calculate cost of service #2 based on known data. The known data are rates (0,80 and 0,68: its permanent) and total incl.VAT 21%. Variable data in column C…
minto
  • 151
  • 2
  • 12
0
votes
1 answer

How can I read the first n rows of table a based upon the number of rows in table b?

I have a table "L20" that contains 1 to 20 values "HDIF" in it, sorted in ascending order. I need to extract the first 1 to 10 of those values into table "T10" depending upon the number of values in table "L20". I'm using Windows 10, Libreoffice…
Bruce Reirden
  • 13
  • 2
0
votes
1 answer

An exception occurred Type: com.sun.star.lang.IllegalArgumentException Message: Unsupported URL <>: "from LoadEnv::startLoading"

I have an issue with LibreOffice base Printing reports from an external form. I try to make button function to print all report but failed. Sub Reportstart(oEvent As Object) Dim oField As Object Dim oForm As Object Dim oDocument As Object Dim…
Micah
  • 3
  • 2
0
votes
1 answer

BASIC runtime error. Argument is not optional

I could not figure out whats the problem is Sub Reportstart(oEvent As Object) Dim oFeld As Object Dim oForm As Object Dim oDocument As Object Dim oDocView As Object Dim Arg() oField = oEvent.Source.Model oForm = oField.Parent sURL =…
Micah
  • 3
  • 2
0
votes
2 answers

All unique combinations of given length from list of values in Libre Office

I have several, let's say six, different values. Can be numbers from 1 to 6. I want to quickly list all unique combinations of four, so 1-2-3-4, 1-2-3-5 ... 3-4-5-6, all of them, but without any numbers showing more than once. I'd like to do it in…
eworm
  • 27
  • 6
0
votes
0 answers

C# libreoffice base connection

i want make login form in c#. but i dont have access. and i cant use sql server . can you help me. why am i getting an error i make this code OdbcConnection con; OdbcCommand cmd; OdbcDataReader dr; private void…
Acbst
  • 1
0
votes
1 answer

LibreOffice homework. Resolving redundancy. "translating" two foreign keys (either of which is absent) into one (supertype)

I am using LibreOffice Base with embedded HSQLDB for educational purposes. The subject area is MOOCs. I have the following entities: Student, Teacher, User(superclass), Course, Forum, Question, Progress Journal. For Course I want to distinguish…
Andrew
  • 125
  • 1
  • 8
0
votes
1 answer

Libreoffice Base macro - How to make visible/hide a control on a form?

I created a database Form with 2 comboboxes, Combo1 and Combo2. Combo2 visibility depends on Combo1 status: Combo1 checked, Combo2 visible; Combo1 unchecked, Combo2 hidden. I expected to find something like Combo2.setVisible(Combo1.isVisible()) but…
Alex Poca
  • 2,406
  • 4
  • 25
  • 47
0
votes
1 answer

How to fix :"Not Enough Stack Memory" when trying to load() with OfficeDatabaseDocument UNO service

I try to familiarize myself with the usage of Macro and UNO API on LibreOffice Base, i tried to open my .odb file with the UNO OfficeDatabaseDocument (DOC here :…
Ekiza
  • 31
  • 6
0
votes
1 answer

FB3.0 Dateadd() throws syntax error in where section of query

I am trying to compare the date modified (field type: Timestamp) with a value that is based off of a month before the current date. I keep getting a syntax error when using the function DateAdd(). I Am Using Libreoffice base 6.2.3.2 (x64) and…
aaron stevenson
  • 3
  • 4
1 2 3
…
11 12