질문하기

Alex Thurgood's profile - activity

2020-06-02 18:13:15 +0100 질문에 댓글을 달았습니다 LibreOffice Base - the lines to link fields in queries and relationships are not showing - why?

Which desktop environment ? KDE ?

2020-06-02 18:09:58 +0100 질문에 댓글을 달았습니다 Problem pasting dates into Base

Please also indicate your locale / language and timezone setup, as this can have an influence on the Calc copy maneuver.

2020-06-02 13:46:28 +0100 질문에 댓글을 달았습니다 base: Some data from table doesn't show in the form. Why?

@Jackbootthug : how long is the field for the information you are attempting to store ? Could it be that you have reache

2020-06-02 13:36:48 +0100 질문에 댓글을 달았습니다 Error setting up first database?

LOVanilla provided by Collabora doesn't support embedded hsqldb ODB file or anything Java related. Any and all functiona

2020-06-02 13:32:35 +0100 코멘트달린 답변 insert timestamp in a base field pressing a button in a form

Just my personal preference perhaps, but would it not be easier just to use a prepared SQL statement to inject or create

2020-06-02 13:19:35 +0100 질문에 댓글을 달았습니다 Base - How to enter new data

@Tecknode : have you tried double-clicking on any of the tables in your list of tables that you can reach by clicking

2020-06-02 13:16:09 +0100 질문에 답변하였습니다 Base Printing Forms

A Form is to all intents and purposes a document container (ODT or ODS) with a layout of form objects. In order to set a

2020-06-02 13:05:09 +0100 코멘트달린 답변 Where can I find sample databases for Base?

You could also try looking here: https://forum.openoffice.org/en/forum/viewforum.php?f=100

2020-06-02 12:58:37 +0100 질문에 댓글을 달았습니다 No Connection to HSQLDB Embedded Database

@Basin : Let me guess, are you using LibreOffice Vanilla from the AppStore ? If so, then you won't be able to create any

2019-10-23 11:37:13 +0100 코멘트달린 답변 Does LibreOffice run in macOS 15 - Catalina

Ready would imply that it had been tested on Catalina. It hasn't. In fact, LO is almost never tested by QA against upcom

2019-10-23 11:10:19 +0100 코멘트달린 답변 LO Database newbie - Firebird error trying to create new project

A suggested workaround is to change your large varchar field definitions to CLOB fields instead.

2019-10-23 11:04:18 +0100 질문에 답변하였습니다 LO Database newbie - Firebird error trying to create new project

The problem lies in there being a fixed maximum of 64K for any insert statement with the current version of Firebird. h

2019-10-23 10:59:43 +0100 질문에 댓글을 달았습니다 How do I use LO Calc as form to enter data into a database?

Yes, you can, using drag and drop (or copy/paste) of selected rows from the Calc sheet to an open ODB file configured to

2019-10-23 10:51:05 +0100 질문에 답변하였습니다 Spaces in field names LO Base

The answer is to avoid using spaces in your field names, aliases, queries, etc, as bugs keep popping up in parts of the

2019-10-23 10:46:52 +0100 질문에 댓글을 달았습니다 Libreoffice failed to save database entries

Giving an example with syncthing, if I edit an ODS or and embedded hsqldb ODB file, save it and keep it open, those chan

2019-10-23 10:44:31 +0100 질문에 댓글을 달았습니다 Libreoffice failed to save database entries

I seem to recall that "autosave" doesn't work for ODB files, at least with embedded hsqldb ODB files, the reason being t

2019-10-23 10:34:28 +0100 질문에 댓글을 달았습니다 Libreoffice failed to save database entries

I seem to recall that "autosave" doesn't work for ODB files.

2019-10-23 09:31:59 +0100 코멘트달린 답변 Does LibreOffice run in macOS 15 - Catalina

The real question should be : is it Catalina ready ? The answer to that is no.

2019-10-23 09:30:04 +0100 질문에 답변하였습니다 is the latest version compatible with Mac OS Catalina 10.15

The 32bit will indeed not run on Catalina. Current releases of LibreOffice, be it LO6282 or LO6322 or LibreOfficeVanilla

2019-09-06 15:59:10 +0100 코멘트달린 답변 Howto create form based on calc table alone?

Not sure about all that working as a fillable PDF though, i.e. if you put the data source for your lists on a separate s

2019-09-06 15:40:40 +0100 질문에 답변하였습니다 Howto create form based on calc table alone?

You shouldn't need a database for this, just the form controls. Ignore the form control wizard if it is started automat

2019-09-06 15:14:23 +0100 질문에 답변하였습니다 Mail Merge - drag and dropping fields not working

I'm guessing that this issue has been solved since the question was posted back in 2015?

2019-09-06 15:13:02 +0100 질문에 답변하였습니다 Libre base

If the ODB points to server backend db engine, then put the ODB file in a shared directory and make it read-only. This s

2019-09-06 11:29:30 +0100 코멘트달린 답변 template document for Base forms via assistent (wizard)

You can always create your own standalone form manually as well via the GUI, save it as a template, and then use that as

2019-09-06 11:27:45 +0100 질문에 답변하였습니다 template document for Base forms via assistent (wizard)

It is, from what I understand, hardcoded in the wizard code, unfortunately. It should however be possible to create sta

2019-07-29 18:00:25 +0100 질문에 댓글을 달았습니다 Base communication link failure

@Jody, please provide the complete error message you get. Additionally, can you actually access the mysql database from

2019-02-22 11:54:18 +0100 질문에 댓글을 달았습니다 Wizards in Base do not run

Does this still occur in current versions of LO for OpenSuse ?

2019-02-22 11:52:23 +0100 질문에 댓글을 달았습니다 Syndax error on base with LOAD DATA

Without any further information as to which database you have exported from and which database to are attempting to load

2019-02-22 11:40:06 +0100 질문에 댓글을 달았습니다 Base form 'input required' does not work

It would be helpful if the link to the bug could somehow indicate that the bug has been fixed. Currently, someone readin

2019-02-22 11:35:11 +0100 질문에 답변하였습니다 Libre office base intermittently crashes after leave an invoice screen

Simple answer : the embedded database engine (hsqldb) that has been the default with LibreOffice Base, whilst a good eng

2017-12-03 00:07:25 +0100 받은 배지  훌륭한 답변 (source)
2016-10-24 17:54:24 +0100 질문에 댓글을 달았습니다 how to get Mac OS X 10.9.5 to verify installation
2016-10-13 17:52:45 +0100 질문에 댓글을 달았습니다 LibreOffice will not open on Sierra
2016-10-13 17:52:27 +0100 질문에 댓글을 달았습니다 Problems with icons
2016-10-13 17:52:00 +0100 코멘트달린 답변 Mac OS Sierra crashes drawing module
2016-10-13 17:51:12 +0100 질문에 댓글을 달았습니다 LibreOffice crashes after an OS reboot or cold start
2016-10-13 17:50:49 +0100 질문에 댓글을 달았습니다 Program Launch fail

Could be a manifestation of bug : https://bugs.documentfoundation.org/s...

2016-10-13 17:49:12 +0100 질문에 댓글을 달았습니다 Update for macOS Sierra Problems

For that to happen, the following bug needs to be resolved : https://bugs.documentfoundation.org/s...

2016-10-13 17:48:23 +0100 질문에 댓글을 달았습니다 LibreOffice Extremely Slow in Mac OS Sierra

Having your hardware config might help, if only to eliminate other potential known issues. Also, whether or not you have, or are attempting to acess your files over a network share. Otherwise, I can not confirm any particularly debilitating slowness, and I have LO52 running on Sierra with a Mac-min 2010 and a MBPro 2013. While the Mac mini is slow generally since the upgrade to Sierra, LO isn't noticeably even more slow than it was before the upgrade to 10.12. On the MBPro, performance is OK

2016-10-13 17:37:12 +0100 질문에 답변하였습니다 LibreOffice hangs on macOS Sierra
2016-10-08 05:06:22 +0100 받은 배지  족집게 도사 (source)
2016-09-23 16:43:23 +0100 질문에 댓글을 달았습니다 LibreOffice 5.2.1 & 5.1.5 crashing after upgrading to macOS Sierra (10.12)

Someone is trying to work on a fix, but it doesn't appear to be working yet.

2016-09-23 16:39:30 +0100 질문에 댓글을 달았습니다 LibreOffice 5.2.1 & 5.1.5 crashing after upgrading to macOS Sierra (10.12)
2016-09-14 15:32:06 +0100 질문에 답변하였습니다 Libreoffice Base JRE "missing"

Yanni, you need to install a complete JDK, a JRE by itself is no longer recognized. Additionally, for JDK versions greater than 1.8.0_99 (e.g. 101, 102) , you will need LibreOffice 5.2.1 or 5.1.6. You may also need to tell LibreOffice where to find the installed JDK once you have installed it, by pointing to it specifically under LibreOffice > Preferences > Advanced.

2016-06-01 14:58:20 +0100 코멘트달린 답변 sqlite with Base ?

The Devart ODBC connector extension is neither free, nor available under a free licence.

2016-05-30 17:11:44 +0100 질문에 댓글을 달았습니다 Complex forms with data and data entry from many to many relationship tables

Rather than re-inventing the wheel, you might want to look at this project instead (I have only just discovered this, and it looks interesting) :

http://plasmidb.sourceforge.net/intro...

2016-05-30 16:39:54 +0100 질문에 댓글을 달았습니다 Complex forms with data and data entry from many to many relationship tables

I might add that using the default embedded hsqldb as the database engine for such a db is probably not the greatest of ideas, depending on whether or not you are going to include sequence data in one of the fields. You would be better off using a "split" hsql database (see other posts on splitting hsql out for how to do that) or else a server backend db engine such as MariaDB/MySQL or Postgresql.

2016-05-30 16:11:40 +0100 질문에 답변하였습니다 Libre Office Database not linking to Java

Gary, Make sure you are using the same bit-type JRE as the bit-type of your LibreOffice application. If you are using a 32bit LibreOffice application, then you need a 32bit JRE. If you are using a 64bit LibreOffice application, which I am assuming you are, you need a 64bit JRE. You can not mix and match between bit versions.

2016-05-30 16:02:40 +0100 질문에 답변하였습니다 Running Chrome Version 50.0.2661.102 m. Libreoffice says no installation found yet JRE option on Tools Libreoffice Advanced option is checked. How do I fix this?

You need to install a complete JDK. A JRE on its own is no longer detected in recent versions of LibreOffice and current versions of OSX.

2015-06-26 15:27:24 +0100 코멘트달린 답변 In Base, is it possible to have one form look at two tables?

Or you could have read the documentation : link text

page 103 and onwards