Stack Overflow
Stack Overflow

Questions tagged [openoffice-base]

OpenOffice Base is the database management application of the OpenOffice project.

OpenOffice.org Base is the database management application of the OpenOffice.org project.

Since version 2.0 OpenOffice.org ships its own database HSQLDB. HSQLDB is a database written entirely in Java.

BASE is the database frontend of OpenOffice.org. Through drivers it can also communicate with other databases besides HSQLDB.

65 questions
1
vote
2 answers

Return most recent records for each value in a GROUP BY field?

I'm a hospital doctor and am trying to produce a report from OO.org Base that will give me the three most recent blood tests for each of my patients. I have a database that contains the following tables: "pat" (details of each unique…
user1350000
  • 41
  • 1
  • 2
0
votes
0 answers

How can I edit document like doc,PDF in my browser?

I have a client and he wants to open the document in browser. Edit the document and save it back to database or NextCloud. I am using angular as front-end technology and python flask as back-end . I have doubt whether it is possible or not and I am…
Samresh Kumar Jha
  • 55
  • 1
  • 2
  • 9
0
votes
1 answer

How to insert data to Open Office Base using Visual Basic?

I have a problem in inserting data from a sheet into database. Some people say that this can be done using (UNO) RowSet, but i find minimal example for this. Could anyone give my a sampe of this? Open for other ways, as long it use UNO
indrap
  • 760
  • 2
  • 10
  • 18
0
votes
0 answers

How to input Cell Value from OpenOffice Calc into AS400 textfield / screen using macros?

I want to automate my Processes in AS400 using OpenOffice Calc. The idea is to enter a value in OpenOffice Calc (e.g "34) and then have that value put into the AS400 screen. Is that at all possible? If so then I can create / record a macro in AS400…
DaLi
  • 1
0
votes
1 answer

Looking for OpenOffice base SQL reference

(I posted this elsewhere, but this may be a better forum.) I recently bought a new laptop and am trying to avoid MS Office. I've loaded OpenOffice 4.1.8, but am having issues writing query statements in OO base. Supposedly, OO base uses the HyperSql…
deke
  • 13
  • 3
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
0
votes
3 answers

Cloning a PHP/MySQL database app (w/ some automation) in MS Access or OpenOffice.org Base

I wasn't sure whether to ask this here or on SuperUser, so I apologize if it doesn't belong here. I created a small PHP/MySQL database app to manage the customer loyalty data for my mom's shop, intending to set it up locally on her cash register…
Mike Turley
  • 1,172
  • 1
  • 9
  • 26
0
votes
1 answer

What is wrong with this SQL command for Apache Open Office Base?

I am an online student and have just started to learn SQL. I am doing an exercise where I have to create a new database with the following command in Apache Open Office 4.1.3. CREATE TABLE "tbl_customers" ("customer_id" INTEGER IDENTITY,…
Krisztian Toth
  • 57
  • 3
  • 13
0
votes
1 answer

OpenOffice Base - Merge >200 tables into one

I am new to OpenOffice Base. In a couple of hours I will have about 290 tables with identical headers. What is the quickest and easiest way to merge all these into one (1) single table?
Manfred W.
  • 1
0
votes
2 answers

Open Java DB database in OpenOffice Base or Microsoft Access

I created a database in NetBeans, and I was wondering if it was possible to open it in OpenOffice or Access for easier ease of use. The database is stored locally. Thank you in advance!
Bradley Pearl
  • 23
  • 1
  • 6
0
votes
1 answer

Transfer a data set from openoffice base to calc

After I did a query in openoffice-base over a customized form I want to transfer a selected set of data into a template openoffice-calc table. I know I can access the data set in openoffice-calc via pressing the Data Source (F4) button but then I…
Tobias L.
  • 107
  • 6
0
votes
0 answers

Forms & reports keep disappearing in open office base

Heads up I am very new to open office base so I suspect I am just missing some ui nuance. Setup I have a mysql connection to a simple database. I update the structure in sequalpro then create forms and reports in open office base to same myself all…
danielson317
  • 3,121
  • 3
  • 28
  • 43
0
votes
1 answer

HSQLDB insert if doesn't exists, update if exists

I have a problem with my database based on HSQLDB (OpenOffice 3.3.0). I am trying to create SQL command that will select rows with specified columns from source table and copy it across to the destination table keeping in mind that if record does…
Mikey
  • 11
  • 1
0
votes
1 answer

How to Programmatically add or remove items in ListBox FORM control

I am having a problem with OpenOffice.org ListBox Form control. I have built a small form (not dialog) that contains a textbox and ListBox and 2 buttons. Sub AddToList_ButtonClicked() Dim oThisDoc As Object Dim oForms as Object Dim oForm as Object…
zapper
  • 181
  • 3
  • 15
1 2
3
4 5