Ask Your Question

tommasz's profile - activity

2020-04-21 14:10:53 +0200 received badge  Famous Question (source)
2019-06-24 21:20:20 +0200 received badge  Famous Question (source)
2019-05-31 22:21:02 +0200 commented answer LibreOffice Base convert an HSQLDB to Firebird?

I'm not willing to post the file. I'll stick with HSQLDB for now and keep seeing how newer versions perform.

2019-05-31 20:45:36 +0200 commented answer LibreOffice Base convert an HSQLDB to Firebird?

It does generate an error. From the original post: Symptoms: First sign is a blank dialog box with an "OK" and "More" b

2019-05-31 18:13:08 +0200 commented answer LibreOffice Base convert an HSQLDB to Firebird?

There is an issue with the SQL syntax of the DATEDIFF function in the query, the dd should not be enclosed in single quo

2019-05-31 15:24:23 +0200 commented answer LibreOffice Base convert an HSQLDB to Firebird?

Fixing the DATEDIFF function doesn't do anything to deal with the fact that the conversion deletes all my table data.

2019-05-30 14:31:08 +0200 received badge  Notable Question (source)
2019-05-29 22:44:56 +0200 received badge  Popular Question (source)
2019-05-29 14:34:22 +0200 asked a question LibreOffice Base convert an HSQLDB to Firebird?

LibreOffice Base convert an HSQLDB to Firebird? I've been trying to do this with a small database I have without success

2019-05-29 14:23:32 +0200 received badge  Notable Question (source)
2019-05-14 15:43:15 +0200 marked best answer How to display the difference of two date fields on a Base form?

My HSQLDB has a pair of date fields that I'd like to use to calculate a duration to display on the input form. The form is based on a query that contains a bunch of fields including one that has a numeric calculation based on two fields. But it appears I can't do any calculations on date values in the query so I thought I'd do it on the form. The Days() function is what I want to use but so far I haven't been able to do that. If I put that in a Numerical Field's Data Value it never displays anything. I've been unable to find anything useful on this so far.

LO v6.1.5.2 Mac OS X 10.14.4

2019-05-14 15:43:15 +0200 received badge  Scholar (source)
2019-05-13 18:53:46 +0200 received badge  Popular Question (source)
2019-05-13 14:21:59 +0200 commented question How to display the difference of two date fields on a Base form?

It does, thanks. Everything I had googled made it look like it was specific to MS SQLServer.

2019-05-13 13:37:48 +0200 asked a question How to display the difference of two date fields on a Base form?

How to display the difference of two date fields on a Base form? My HSQLDB has a pair of date fields that I'd like to us