Create a new embedded HSQLDB.
Try running the CREATE statements of your script file. If this works, you get all the tables, relations and indices.
Copy the data.
Copy queries forms and reports.
Search found 31049 matches
- Sat Apr 13, 2024 6:45 pm
- Forum: Base
- Topic: Convert server database to embedded
- Replies: 3
- Views: 398
- Sat Apr 13, 2024 3:34 pm
- Forum: Base
- Topic: Convert server database to embedded
- Replies: 3
- Views: 398
Re: Convert server database to embedded
This is a backup script for Windows which safely backups the database without stopping the service. Adjust the absolute paths and names. Start it from the Windows task scheduler. REM Backup one database SET DBN=MyDatabase SET HOST=192.168.1.1 SET BDIR=E:\hsql\database\backups\ SET URL=jdbc:hsqldb:hs...
- Mon Apr 08, 2024 7:25 pm
- Forum: Calc
- Topic: [Solved] Extract numbers from a string of alphanumeric text
- Replies: 27
- Views: 94198
Re: [Solved] Extract numbers from a string of alphanumeric text
LibreOffice only: =REGEX(A1;"([^[:alpha:]])+")
- Fri Apr 05, 2024 6:43 pm
- Forum: Calc
- Topic: [Solved] Identify presence of text in a cell
- Replies: 2
- Views: 477
Re: Identify presence of text in a cell
=ISNUMBER(FIND("1920";A1))
- Tue Apr 02, 2024 9:16 pm
- Forum: MS Windows
- Topic: [Solved] What is the JRE location?
- Replies: 26
- Views: 2483
Re: JRE location
OpenOffice is walking dead. Replace it with LibreOffice which is the actively maintained successor to OpenOffice but still very much like OpenOffice. https://www.libreoffice.org/discover/libreoffice-vs-openoffice/ Anything related to macros does not require any Java. There is hardly anything in Libr...
- Tue Apr 02, 2024 8:57 pm
- Forum: Calc
- Topic: [Solved] Search and index - then fill
- Replies: 8
- Views: 860
Re: Search and index - then fill
Just open the database document and open the form(s).
- Tue Apr 02, 2024 8:47 pm
- Forum: Calc
- Topic: [Solved] Search and index - then fill
- Replies: 8
- Views: 860
Re: Search and index - then fill
Forget the database.
- Tue Apr 02, 2024 8:29 pm
- Forum: Calc
- Topic: [Solved] Search and index - then fill
- Replies: 8
- Views: 860
- Tue Apr 02, 2024 7:56 pm
- Forum: Calc
- Topic: [Solved] Search and index - then fill
- Replies: 8
- Views: 860
Re: Search and index - then fill
This office suite comes with a database component.
- Fri Mar 29, 2024 9:07 pm
- Forum: Calc
- Topic: [Solved] Running total in accumulator
- Replies: 6
- Views: 1006
- Mon Mar 25, 2024 10:09 pm
- Forum: Macros and UNO API
- Topic: [Solved] Change percent in cell to value*100
- Replies: 4
- Views: 811
Re: Need a Macro to change Percent in Cell to Value*100
Find/Replace % with nothing and you get the decimal cell value.
- Thu Mar 21, 2024 8:21 pm
- Forum: Calc
- Topic: Hyperlink to today's date
- Replies: 18
- Views: 1578
- Tue Mar 19, 2024 10:30 pm
- Forum: Tables & Queries
- Topic: [Solved] SQL Query: Need "Time" + "MinuteLen" as "EndTime"
- Replies: 10
- Views: 964
Re: [Solved] SQL Query: Need "Time" + "MinuteLen" as "EndTime"
Any operation with a Null value returns Null.
- Tue Mar 19, 2024 8:02 pm
- Forum: Tables & Queries
- Topic: [Solved] SQL Query: Need "Time" + "MinuteLen" as "EndTime"
- Replies: 10
- Views: 964
Re: SQL Query: Need "Time" + "MinuteLen" as "EndTime"
Embedded HSQL does not have a DateAdd function like most other database engines have. As a work-around, you can calculate the day fractions and add them as you would do in a spreadsheet. A formatted control on a form or report can display this value as a time. SELECT *, Hour("Time")/24 + M...
- Tue Mar 19, 2024 12:56 pm
- Forum: Calc
- Topic: [Solved] Set chart Data Rages from cell value
- Replies: 2
- Views: 701
Re: Change range of cells automatically
Tools>Options>Calc>"Expand references when rows/columns are inserted " = ON Now you can insert new cells anywhere within or directly below the referenced range and all references in formulas, names, charts, conditional formatting etc. will expand automatically. With that setting turned off...
- Fri Mar 15, 2024 10:01 am
- Forum: Writer
- Topic: Merge documents from your Thunderbird address book
- Replies: 12
- Views: 994
Re: Merge documents from your Thunderbird address book
Hi guy, Didn't you notice that the user can merge emails simply by activating the Option menu? Is your extension by the way really necessary? Regards Nick In the LibreOffice options, you can specify your outgoing SMTP Server with log-in credentials. However, this feature is broken currently. You ca...
- Fri Mar 08, 2024 1:36 pm
- Forum: Macros and UNO API
- Topic: Get all Annotations/Comments/Notes
- Replies: 17
- Views: 2217
Re: Get all Annotations/Comments/Notes
Annotations are special types of TextFields. MRI records the following:
[Tutorial] Introduction into object inspection with MRI
Code: Select all
Sub Snippet
oTextFields = ThisComponent.getTextFields()
oObj2 = oTextFields.createEnumeration()
oObj3 = oObj2.nextElement()
End Sub
- Wed Mar 06, 2024 7:56 pm
- Forum: Extensions
- Topic: SQLite in LibreOffice / OpenOffice Base
- Replies: 19
- Views: 7715
- Tue Mar 05, 2024 6:41 pm
- Forum: Extensions
- Topic: SQLite in LibreOffice / OpenOffice Base
- Replies: 19
- Views: 7715
Re: SQLite in LibreOffice / OpenOffice Base
Trying to update from 1.1.5 to 1.2.2 on Version: 24.2.0.3 (X86_64) / LibreOffice Community Build ID: da48488a73ddd66ea24cf16bbc4f7b9c08e9bea1 CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: x11 Locale: de-DE (de_DE.UTF-8); UI: en-US Calc: threaded Error while installing extension jdbcDriver...
- Sun Mar 03, 2024 8:05 pm
- Forum: Calc
- Topic: [Solved] 03/04/24 changed to ¾ 24 (fraction)
- Replies: 5
- Views: 933
Re: Can't format cells for date
Hello Sir, I've seen for myself. Please find enclosed test file. Regards Nick Your column A uses the default locale, which is German(Germany) in my case and the dates are displayed like 31.12.99 here. If your default locale is English(UK), 31/12/99 might be the displayed date. Column B uses English...
- Sun Feb 25, 2024 11:50 pm
- Forum: Forms
- Topic: [Solved] Form control filter by date
- Replies: 22
- Views: 20611
Re: [Solved] Form control filter by date
How to filter by criteria in form controls without any macro: http://forum.openoffice.org/en/forum/do ... p?id=11663 (search this forum for "power filtering").
LibreOffice canceled the integer dates and times in favor of date and time structs.
LibreOffice canceled the integer dates and times in favor of date and time structs.
- Tue Feb 20, 2024 10:11 pm
- Forum: Calc
- Topic: [Solved] Report of product sales
- Replies: 6
- Views: 1167
Re: Formula to have list of how many of each product sold
The attachment has no formula. Calc Guide Chapter 8 - Using a Pivot Table
- Tue Feb 20, 2024 4:53 pm
- Forum: Calc
- Topic: [Solved] LOOKUP in LO Calc
- Replies: 3
- Views: 744
Re: LOOKUP in LO Calc
LOOKUP in LO Calc It's the same LOOKUP function since the very first version of Visicalc in the year 1979 and successive spreadsheet applications such as Lotus 1-2-3, Excel and Calc. LOOKUP never did what most users expect it to do. In your specific example =CODE(D1)-43 returns a correct result wit...
- Mon Feb 19, 2024 9:05 pm
- Forum: Extensions
- Topic: SQLite in LibreOffice / OpenOffice Base
- Replies: 19
- Views: 7715
Re: SQLite in LibreOffice / OpenOffice Base
By the way, "OOo" in the name jdbcDriverOOo is misleading for two reasons. "OOo" refers to the product "OpenOffice.org" which was named after the website hosted by Sun Microsystems. - Since 2011 the product name is Apache OpenOffice (AOO). - Your package is incompatible...
- Sat Feb 17, 2024 6:34 pm
- Forum: Extensions
- Topic: SQLite in LibreOffice / OpenOffice Base
- Replies: 19
- Views: 7715
Re: SQLite in LibreOffice / OpenOffice Base
Somehow, the Thunderbird application grabs all access rights, no matter if it is started before or after LO Base. The Base frontend gets into some "frozen" state when TB is running. My problem is, that I can not open the database in read-only mode, so it does not interfere with TB in any w...
- Mon Feb 12, 2024 5:04 pm
- Forum: Extensions
- Topic: SQLite in LibreOffice / OpenOffice Base
- Replies: 19
- Views: 7715
Re: SQLite in LibreOffice / OpenOffice Base
Great job. This driver allows me to access the contacts database of the Thunderbird mail client without too many issues. Can you tell me if it is possible to establish a read-only connection? If I load the database document after the Thunderbird client, the database is locked (does not show any tabl...
- Thu Feb 08, 2024 9:31 pm
- Forum: Calc
- Topic: [Solved+Issue] Date format and date entry do not match
- Replies: 17
- Views: 2284
Re: Date format and date entry do not match
The locale is the relevant setting. You can set it for the entire office document, for cells and cell ranges, text fields, for anything numeric in templates for documents. How to enter a date in a spreadsheet cell (Calc, Excel and others): 1/ enters the first day of current month 1/2/ enters this ye...
- Tue Feb 06, 2024 8:51 pm
- Forum: Base
- Topic: Updating records from a query again, again
- Replies: 14
- Views: 2150
- Mon Jan 29, 2024 7:09 pm
- Forum: Macros and UNO API
- Topic: [Solved] [Basic] Replace Sheet with a new one
- Replies: 4
- Views: 1525
Re: [Basic] Replace Sheet with a new one
Use a document template.
- Thu Jan 25, 2024 6:23 pm
- Forum: Forms
- Topic: [Solved] Subform From Query Not Linking with Mainform Record
- Replies: 5
- Views: 1316
Re: Subform From Query Not Linking with Mainform Record
One-to-many and many-to-many relations in tables, queries and forms with subforms and lisboxes.: download/file.php?id=11250