Ask Your Question
0

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

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

LO_Fans gravatar image

updated 2020-07-14 16:24:25 +0100

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

Comments

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

1 Answer

Sort by » oldest newest most voted
0

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

Ratslinger gravatar image

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

Hello,

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

Comments

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 +0100 )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 +0100 )edit

Hello,

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 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 78 times

Last updated: Feb 17 '20