Ask Your Question

TheDatabaseGuy's profile - activity

2016-07-18 19:52:18 +0200 received badge  Famous Question (source)
2016-07-10 21:30:22 +0200 received badge  Notable Question (source)
2016-07-10 06:19:13 +0200 received badge  Popular Question (source)
2016-07-09 19:58:53 +0200 commented answer LibreOffice requires a Java runtime environment (JRE) to perform this task. Please install a JRE and restart LibreOffice

Great! Thanks. I downloaded the Java SE Development Kit 8 and it all worked fine. I really appreciate your assistance.

2016-07-09 18:43:57 +0200 asked a question LibreOffice requires a Java runtime environment (JRE) to perform this task. Please install a JRE and restart LibreOffice

It appears that macOS 10.12 Sierra is going to support Java 6.

However, when clicking on the TABLES option, “LibreOffice requires a Java runtime environment (JRE) to perform this task. Please install a JRE and restart LibreOffice.” appears.

When checking LibreOffice > Preferences > LibreOffice > Advanced, “Use a Java Runtime Environment” is ticked but no Runtime environments are listed – even after installing Java 8 OR Java 6.

Clicking on ‘add’ doesn’t seem to help as it doesn’t tell you where to add a Java Runtime Environment from. Guessing it’s /Library/Java/JavaVirtualMachines doesn’t help as only the 1.6.0.jdk folder is present and selecting it only results in “The folder you selected does not contain a Java runtime environment. Please select a different folder.”

Thoughts?

2016-04-05 19:01:22 +0200 received badge  Famous Question (source)
2016-03-12 15:09:32 +0200 received badge  Popular Question (source)
2016-03-11 21:58:24 +0200 received badge  Famous Question (source)
2016-03-11 21:58:09 +0200 received badge  Famous Question (source)
2016-03-09 17:52:32 +0200 received badge  Notable Question (source)
2016-02-12 00:57:30 +0200 received badge  Popular Question (source)
2016-02-10 11:21:46 +0200 asked a question How to use a query to pull out records which exist in one table but not the other

How can I use a query to pull out records which exist in one table but not the other?

An SQL Inner Join will only find records that DO match in both. A Left or Right Join will pull out ALL records from one table.

Basically I have two identical structured tables, most records appear in both tables but table 2 has extra records and possibly a few records which, while existing in table 1, have been updated.

2016-01-15 14:57:16 +0200 received badge  Notable Question (source)
2016-01-02 19:04:51 +0200 received badge  Popular Question (source)
2015-12-31 15:07:14 +0200 asked a question How long does it take for moderation of posts is not required?

I'm new here and have made a few posts (questions and answers) but I notice my posts are moderated which means there's a delay before my posts appear.

How long should it take before the requirement for moderation is removed? Do I need to have achieved a certain number of posts first?

Thanks!

2015-12-31 15:07:11 +0200 answered a question Simple division symbol

Not sure I fully understand.

Do you mean you want to actually type the division symbol so it appears like this: ÷ ?

If so, on a Mac, you can press OPTION key and the '/' symbols to get ÷

On Windows, I think you hold down the ALT key and type the number 0247 before letting go of ALT.

2015-12-30 22:52:17 +0200 received badge  Notable Question (source)
2015-12-30 21:47:36 +0200 received badge  Popular Question (source)
2015-12-28 11:58:27 +0200 commented question How to calculate the numbers of days between two dates in a query in base?

I've tried: DAYS(DateArrived; DateArrived) But this produces "Invalid expression"

I've trying: DAYS(DateArrived, DateArrived) But this produces "Access is denied: DAYS in statement [SELECT "DatePurchase" "DatePurchase", "DateArrived" "DateArrived", DAYS( "DateArrived", "DateArrived" ) "DayTwo" FROM "T_Drives"]

Pulling my hair out!!

2015-12-28 11:58:21 +0200 asked a question How to calculate the numbers of days between two dates in a query in base?

How can I calculate the numbers of days between two dates in a query in base?

Simple example: In a query I have a field called DateArrived and another called DatePurchase. Both display fine.

I added a field called NOW() and it correct showed the current date on each record.

I then added a field called:

DateArrived DatePurchase

(..and Base converted it to:)

"DateArrived" - "DatePurchase"

..in order to calculate the number of days between the two dates. I got the error:

SQL Status: 37000 Error code: -16 Wrong data type: java.lang.NumberFormatException in statement [SELECT "DatePurchase" "DatePurchase", "DateArrived" "DateArrived", "DateArrived" - "DatePurchase" "Days" FROM "T_Drives"]

How can I resolve this please?

2015-12-28 11:56:38 +0200 answered a question How to break a for loop

If you want the code to break itself under a certain circumstance, you can set 'i' to 100. That will end the loop.

2015-12-28 11:56:11 +0200 asked a question Where can I find a list of "what's New" in Base 5?

Where can I find a list of "what's New" in Base 5?

I'm watching a Base 4.2 tutorial but want to find out what is new in Base 5 so I can specifically study those new features too.

2015-12-28 11:56:09 +0200 answered a question I install Java but Libreoffice keeps asking for it

It's possible you need Apple's Legacy Java installed.

You can find it here: https://support.apple.com/kb/dl1572?l...

It's version 6 and it require for certain Java applications on Mac.

I've got both version 6 and 8 installed so don't know which my copy of LO is using!

2015-12-28 11:56:06 +0200 answered a question Simple calculation not working

I certainly looks as though the 'numbers' are actually 'text' which will all carry the numeric value 0.

Try summing just two of the numbers to see if you get the same result.

The other option is that ONE of the numbers (if they are numbers) contains a text character (eg. 102 being entered as 1O2 - they look that same except the second one have the capital letter 'O' in it. This might be confusing LO as you are trying to add together fields that are not all numeric.

2015-12-28 11:56:03 +0200 answered a question Can I access an unrecoverable document?

Which computer is this on?

If it was a Mac and you are running Time Machine, you should be able to recover a slightly older version of the file with it.

2015-12-28 11:56:00 +0200 answered a question Can't open "Base" neither create a new project

Under File, it appears as 'Database", not "Base"

Under File>StartCentre it appears as "Base Database"

Are you able to provide a screenshot so we can see what might be going wrong?

2015-12-28 11:55:43 +0200 commented question I cannot get LO offline help to work.

What happens when you try? The answer may well help us help you find an answer.

2015-12-28 11:55:37 +0200 answered a question how to convert files into PDF format on Mac?

The File>Print>PDF option gives you lots of ways to export PDFs. You can, save them, eMail them, add them to iBooks, etc.

image description

2015-12-26 16:04:14 +0200 received badge  Enthusiast
2015-12-24 12:06:40 +0200 received badge  Scholar (source)
2015-12-16 21:08:00 +0200 received badge  Notable Question (source)
2015-12-14 21:56:03 +0200 received badge  Popular Question (source)
2015-12-14 14:25:47 +0200 asked a question How to add LibreOffice Basic code to a form button?

I'm new to coding on LibreOffice Base - can someone please point me in the right direction?

I've create a form containing fields from my query and have added a button to the form.

I want to write and then execute a piece of LibreOffice Basic code when I press the button.

Anything will do at the moment - for example, a message could appear to say "You pressed me!".

I can only see how to assign a pre-defined macro to a button so far (and even then I'm not sure I'm doing it right!)

Help! Please!

2015-11-01 01:42:05 +0200 received badge  Famous Question (source)
2015-10-29 14:09:16 +0200 received badge  Notable Question (source)
2015-10-29 12:37:15 +0200 received badge  Popular Question (source)
2015-10-26 15:13:17 +0200 asked a question LibreOffice requires a Java runtime environment (JRE) to perform this task. Please install a JRE and restart LibreOffice.

I'm running: Base as part of LibreOffice Version: 5.0.2.2 Build ID: 37b43f919e4de5eeaca9b9755ed688758a8251fe Under OS X 10.11.1 With Java (Version 8 Update 65) installed

I'm getting "LibreOffice requires a Java runtime environment (JRE) to perform this task. Please install a JRE and restart LibreOffice." when I try to open a table.

Does anyone know what the problem is and, if I'm running the wrong version of LibreOffice or Java, let me know which version I should be running and when I can get it from?

Thanks all.