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
4
votes
3 answers

Connect to Open Office odb file using jdbc program

I had written following code to connect to OpenOffice db . String db = "C:\\Documents and Settings\\hkonakanchi\\Desktop\\Test.odb"; Class.forName("org.hsqldb.jdbcDriver"); Connection con = DriverManager.getConnection("jdbc:hsqldb:file:" +…
Harshavardhan Konakanchi
  • 4,238
  • 6
  • 36
  • 54
3
votes
1 answer

OpenOffice Base - how to change height of Table Control in Macro?

I've got Table Control in Libre/OpenOffice Base form which is filled dynamically. I want to change height of it to match number of rows. How to do it? I've tried changing getSize() / setSize(), and height property but I'm getting: Property or method…
Jacek Kaniuk
  • 5,229
  • 26
  • 28
3
votes
1 answer

sql dialect in OpenOffice Base

I'm familiar with SQL in SQLite and MySQL, but OpenOffice Base seems to be either very crippled, or I don't understand how to execute raw SQL. I want to do (effectively) this: INSERT INTO t2 SELECT NULL as id, t.foo, t.bar, '' as baz, 0 as quux …
Jason S
  • 184,598
  • 164
  • 608
  • 970
2
votes
1 answer

JDBC/ODBC connection to Informix with Openoffice BASE on Windows 7. Will not show table lists

I've attempted this with ODBC drivers, and JDBC drivers. I'll list both approaches separately. ODBC approach I'm using the ODBC driver found here:…
kevingreen
  • 1,541
  • 2
  • 18
  • 40
2
votes
0 answers

OODB Update with Aggregate Function

I'm trying to update a column in my table "InventoryTable" with the SUM of values returned from Querying my other table "OrderTable" I found several other questions like this here, and composed this statement: UPDATE InventoryTable SET SalesPerMonth…
Josh Jeffers
  • 25
  • 1
  • 6
2
votes
1 answer

How to access openoffice.org database from command line

I have a database built in openoffice.org base (.odb). I would like to open this database using a command line sql client, such as sqlite3 or psql. Can anyone tell me how to make this work? I am running Windows 7 64-bit and have cygwin installed.
ewok
  • 20,148
  • 51
  • 149
  • 254
2
votes
1 answer

Open a form in Libreoffice/Openoffice Base with a specific filter/query

I am creating a Libreoffice Base with multi forms. Form1 is linked to "Projects" table and each Project has multiple tasks, I can display the tasks as sub form within the same Form1, however, each project has many tasks and each task also has sub…
Fahad Alduraibi
  • 372
  • 6
  • 17
2
votes
4 answers

OpenOffice SQL query date selection

I've been searching the web and asked around, but can't seem to find an answer to my problem... I have a running ODBC connection with my FrontBase database in OpenOffice Base. I manage to select everything I want, but when I only want to show the…
user3256812
1
vote
1 answer

Visual basic 2010 to open office base

How do i make the connection between visual basic and open office base, I can only find tutorials showing how to connecting to access. Any help?
user445714
  • 383
  • 1
  • 9
  • 24
1
vote
1 answer

OpenOffice Base LIKE with columns

I have an Open Office database. I'd like to use the LIKE operator with "%" marks between two columns in the same table: SELECT * FROM "table1" WHERE UPPER ( "table1"."a" ) LIKE UPPER ('%' + "table1"."b" + '%' ) But it doesn't work, although SELECT…
balping
  • 7,518
  • 3
  • 21
  • 35
1
vote
1 answer

Is OO Base compatible with MSO Access?

Is Open Office Base compatible with MS Office Access? That is, can I successfully edit an Access-made database from Base? Thanks
Matt
  • 23
  • 4
1
vote
2 answers

SQL - Joining columns from the same table in a Query

SOLVED ! See the answer bellow ! Before I explain my problem I want to apologise for those who would feel this question is too long but I feel like I must give some details to make things the clearer possible. Though, the problem is simple to…
猫IT
  • 412
  • 5
  • 11
1
vote
1 answer

Simple Delete Command in SQL giving error message

I'm fairly new to SQL (I learned it just yesterday). The DBMS application I am using is OpenOffice.org Base on Windows 10. I created a table in my DBMS by the name of Employees, with several records. The Primary Key is EmployeeID (I'll attach a…
starryroad146
  • 11
  • 1
1
vote
0 answers

Best way to run Macro on LibreOffice or OpenOffice SubForm "Fill parameters" Event

I try for more than a week to fill out a SQL query parameter by running a macro on the "Fill Parameters" event in the subform by searching for a method to fill the parameter under the Parameters object with MRI without success. Searches for guides…
Sagi Nadav
  • 295
  • 1
  • 3
  • 14
1
vote
1 answer

Execute SQL query from OpenOffice macro

I have an SQL query which I want to run when a button in my OpenOffice Calc worksheet is pressed. I've found out how to bind a macro to the button, but I can't get a connection to the database it seems (I've created an .odb file and I can run the…
Jdv
  • 962
  • 10
  • 34
1
2 3 4 5