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

OpenOffice lost connection to MySQL on open cursor

Creating reports from OCS-NG Inventory using OpenOffice Base. Because of poor functionality of OOOs Base source editor (it haven't even search facility!), I prefer to develop scripts in MySQL Workbench (both in Windows and in Linux). De-bugged…
Troublemaker-DV
  • 174
  • 1
  • 11
1
vote
1 answer

SQL OpenOffice Base "Not a Condition in Statement"

So I tried using OpenOffice Base and I had a hard time. Now, I have this SQL query here and it works well: SELECT "CUSTOMER"."CREDIT_LIMIT" AS "CREDIT_LIMIT", COUNT(*) AS "TOTAL_NUMBER" FROM "CUSTOMER" WHERE "SLSREP_NUMBER" = 6 GROUP BY…
MrCzeal
  • 55
  • 8
1
vote
1 answer

How to create an update query with Open Office Base?

I want to create basically an update query on Open Office Base (the same way with Ms ACCESS).
Thomas Lamothe
  • 174
  • 1
  • 9
1
vote
1 answer

openoffice-base setting the Criterion of a query column from a Form

In an openoffice-base (ooBase) query, and in setting the Criterion of a column. How do I call a value from a Combo Box [combo_1] in a Form [Form1] to filter the query which produces my report? In MSAccess it is [Forms]![Form1].[combo_1] but I can't…
Terry
  • 11
  • 4
1
vote
1 answer

OpenOfffice Base, inserting the results of a join into a table

I'm pretty new to OpenOfffice Base, but not to SQL. I want to insert into a table the results of a join. It works in the simple case: insert into "tbl1" ("last_name", "first_name") select "last_name", "first_name" from "contacts" but NOT with…
Buz
  • 11
  • 2
1
vote
2 answers

OpenOffice Relations between tables

I'm making a database in OpenOffice, and I was trying to make a relation between tables, but when I make a form and want to test it, it shows me this error.
Mr. Hello_world
  • 85
  • 2
  • 10
1
vote
1 answer

Is it possible to create a parameter query in openoffice base?

In access it is very easy to use it: BETWEEN [minimum] AND [maximum] But what is the syntax in openoffice base?
petie
  • 77
  • 3
  • 13
1
vote
1 answer

Insert data into OpenOffice database

I want to insert data into OpenOffice Database using Java. i was able to fetch the data that i populated myself while creating the database, but I am not able to insert data into table using java code. I used two…
Raj Sehmi
  • 7
  • 1
  • 3
1
vote
1 answer

Open Office Base: How to Create a INSERT Trigger

I am creating a database using OpenOffice Base and some homebrewed sql. Problems come in when trying to reference a foreign key that is numbers and possibly letters. I would like to force the table I am checking the key on to force the inserts to…
Silas Greenback
  • 1,200
  • 8
  • 15
1
vote
1 answer

LibreOffice Base subform displays unrelated records

I would like help solving a problem with a LibreOffice Base subform. I think the subform should be displaying only the records that are related to the record displayed in the parent form. But the subform is actually displaying every record in its…
MetaEd
  • 3,753
  • 1
  • 28
  • 30
1
vote
0 answers

openoffice base won't let me select more than 3 columns

So the following query works fine for me: SELECT DISTINCT StNo,HaulNo,CatCatchWgt FROM HL WHERE SpecCode='126436'; But, when I try to add another column to my selection, like so: SELECT DISTINCT StNo,HaulNo,Year,CatCatchWgt FROM HL WHERE…
AlphabetSoup314
  • 11
  • 2
1
vote
1 answer

Open mdb app using Openoffice 4.0.1

I have an mdb access application that I want to open using openoffice 4.0.1 so how to do it? is it possible?
Willy
  • 9,848
  • 22
  • 141
  • 284
1
vote
1 answer

How to run an sql query on an OpenOffice/LibreOffice spreadsheet from command line?

Well, The title pretty much says it all. I have a set of ODS spreadsheets and I want to run some SQL queries over these spreadsheets and save the result on CSV files. I know I can do that from the GUI, but I need to be able to do it from a batch…
Jeff
  • 953
  • 2
  • 11
  • 21
1
vote
2 answers

Convert doc into pdf

I want to convert word doc into pdf format. I have a cloud base server of java. But problem is I can't install openoffice on it. Can I have any other option to do so. or can I use OpenOffice API without install open office on server.
zeeshan
  • 251
  • 1
  • 4
  • 14
1
vote
1 answer

How to make LibreOffice Base reconnect to a database

I am using LibreOffice Base as a generic database client. Sometimes it loses its connection to some database. Is there a way to reconnect it? I mean, a way other than closing and reopening Base?
brandizzi
  • 26,083
  • 8
  • 103
  • 158
1
2
3 4 5