We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Does Firebird 3.0's Window Function work in LO Base 6.4?

asked 2020-02-17 03:32:18 +0200

LO_Fans gravatar image

updated 2021-05-26 17:08:43 +0200

Alex Kemp gravatar image

Does Firebird 3.0's Window Function work in LO Base 6.4?

I have this query written in SQL:

SELECT "Date", "Qty", SUM( "Qty" ) OVER (Order by "Date" ) as "Daily Qty" FROM "Inventori"

Somehow, the command Sum ("Qty") Over (Order by "Date")

is automatically changed by LO Base with Sum ("Qty") Over ()

I have also tried to put the command on the normal query design mode, but the same thing happens. Does anybody have an Idea what went wrong?

Thank you.

edit retag flag offensive close merge delete


Ratslinger gravatar imageRatslinger ( 2020-02-18 06:34:29 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-02-17 04:40:13 +0200

Ratslinger gravatar image

updated 2020-02-17 04:41:25 +0200


Yes the "Window" functions work in Base. You need to turn on the Run SQL command directly function. This bypasses the interpreter which doesn't allow many items in Firebird or other databases. It is a toggle icon on the toolbar or available from the Edit menu selection:

image description

edit flag offensive delete link more


Thank you for your prompt answer Ratslinger. You're genius. The problem is solved.

But I'm wondering. As I turn on the "Run SQL command directly", suddenly I cannot retreive/select data from another query. (which is possible in 'normal mode') The error sign is

firebird_sdbc error: *Dynamic SQL Error *SQL error code = -204 *Table unknown *Query1 *At line 9, column 1 caused by *isc_dsql_prepare'

LO_Fans gravatar imageLO_Fans ( 2020-02-17 12:44:19 +0200 )edit

You're genius.

Sorry - not even close to being one.

The problem is solved.

Please mark answer as such.

But I'm wondering.

This is a question and answer site. If another question is buried in a comment others cannot find it. Please ask as a new question and be certain to give detailed examples.

Ratslinger gravatar imageRatslinger ( 2020-02-17 20:00:38 +0200 )edit


Please do not close questions as other may have additional information.

Instead, please help others to know the question has been answered by clicking on the ✔ in upper left area of answer which satisfied the question.

Ratslinger gravatar imageRatslinger ( 2020-02-24 01:24:52 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-02-17 03:32:18 +0200

Seen: 88 times

Last updated: Feb 17 '20