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 finish a loop when closing form(window)

This should be really easy but I can't find it out. Im trying to do a loop for saving the form records every minute. Which works but when I close the form the macro keeps running and eventually returns a unwanted error because form is no longer…
dvd251996
  • 5
  • 2
0
votes
1 answer

How to get focus on a subform in LibreOffice Base using tab

The question and answer LibreOffice Base; Tab order from mainform to subform almost solve the issue I have, but not completely. I have a table mytable (id, name, textfield). I'm displaying id and name in a form with a table layout (table control).…
arjan
  • 263
  • 3
  • 11
0
votes
0 answers

User friendly Postgres data input front end options?

I'm working on a native app which uses a PostgreSQL database which I currently update and maintain. The project needs to be updated by non-computer savvy people in the future however so I need to create a user-friendly front end, for untrained staff…
noe.s
  • 13
  • 1
  • 4
0
votes
1 answer

LibreOffice BASIC : Connect to PostgreSQL

I've created a PostgreSQL connection File using LibreOffice Base (6.1) and I can run SQL Queries in there just fine but I was wondering if it's possible to use this Base connection in a LibreOffice BASIC function. I know you can use JDBC connections…
TheLovelySausage
  • 3,838
  • 15
  • 56
  • 106
0
votes
1 answer

Calculated result in Firebird SELECT

Can anyone explain why this works: Select C1, C2, C1 + C2 as C3 from V1,V2 where C2 > 0 and Select C1, C2, C1 + C2 as C3 from V1,V2 where C3 > 0 gives the following error: *Dynamic SQL Error *SQL error code = -206 *Column unknown *C3 *At line 1,…
Michael Murphy
  • 3
  • 2
0
votes
1 answer

SUM() taking from only one row

Two tables: "S" (for "Services") and "Payments". They're tied together via the "S"."ID-S" being referenced as a foreign key: "Payments"."S". I'm trying to create a query for a dropdown list in an "add payment" form, but since I hope to allow for…
eworm
  • 27
  • 6
0
votes
1 answer

MySQL: "Adding/Substracting strings in dialect 3" - error when operating on numeric fields?

I have a Service table and a Payments table. I want my clients to be able to pay for one service with multiple payments, but when I try to create a form for making a payment, I'm unable to make a "ServiceA"."Cost" -…
eworm
  • 27
  • 6
0
votes
2 answers

MySQL: "Payments" table tied to multiple possible "Service" tables

I'll try to be brief and clear. I want a table called "Payments" tied to multiple tables representing multiple types of services offered by a company. It's fairly simple to add a "Payment" foreign key to each of the service tables and link them to…
eworm
  • 27
  • 6
0
votes
1 answer

MySQL: Dropdown list showing different value than the one sent

Is it possible to have a dropdown list in a MySQL form to show a list of values from one field, yet sent a value from another? I want to choose from the list of values in a "Name" field, but for the value actually sent by the form to be the related…
eworm
  • 27
  • 6
0
votes
1 answer

Libre Office Base Query

I'm running a Libre Office Base database to manage my co-op's membership directory. I'm trying to write a query to get a count of current membership, but I keep running into a SQL Status 37000, error code -16, Wrong data type:…
CoMo G-Dawg
  • 401
  • 1
  • 3
  • 18
0
votes
0 answers

Libreoffice Base Custom function

I created a custom LibreOffice Basic function: Function Test() Test = True End Function Then I created a query SELECT Field1, Test() "Test" FROM Table I get SQL Status: HY000 Can not execute query. The function is not compatible. What I am doing…
Claudio Bogado Pompa
  • 43
  • 6
0
votes
1 answer

Libreoffice base. Identity keyword

To create a table with a primary key and a name with the SQL command line I do the following CREATE TABLE "people"( "id" integer primary key, "name" varchar(255) ); this creates a table where I have to worry about the correct setting of the…
theDrifter
  • 1,631
  • 6
  • 24
  • 40
0
votes
2 answers

HSQLDB Query given two dates and time

I need to get the list of users from the date and time entered to the date and time left(but also give the results if no date and time entered). Something is wrong with the results of this query, especially when i type the date/time in/left. The…
user614454
  • 123
  • 2
  • 13
0
votes
0 answers

How to reference a different field from within source criteria of a List/ComboBox in LO Base

I've started working with LibreOffice Base, coming from MS Access and I want to reference a ListBox (lstNameA) selected value from a second ListBox (lstNameB) in order to filter the second ListBoxes records. I've searched but can't find anything.
aSystemOverload
  • 2,994
  • 18
  • 49
  • 73
0
votes
1 answer

libreoffice base create a list filtered by another list's value

I have a table of provinces and a table of cities with ProvienceID. In a form, I want to create a list of cities filtered by selected value of provience list. How can I do that? I can create both lists but Cities list shows all cities from all…
ahmad
  • 3
  • 1
  • 4
1 2 3
…
11 12