Hallo,
Il 08/03/2016 20.36, setysvar setys...@gmail.com [firebird-support] ha
scritto:
> This will not work properly if more than one row of DC are joined to
> the same DT (but then your ORDER BY isn't 100% deterministic). If you
> change the ordering of your query, you also have to change the
Den 07.03.2016 11:16, skrev Luigi Siciliano luigi...@tiscalinet.it
[firebird-support]:
> Hallo,
> I need to write a query with a computed field that contain a
> progressive sum like this table:
>
> DATA DOCUMENTO_ID NUMERO SERIE CARICO SCARICO SALDO
> 01/01 A
LSSBcfs> It has not!
LSSBcfs> RC releases should not be used for production purposes.
Just a note: FB 3 RC2 will become the final release, unless someone
finds a critical bug or regression that would require another RC.
[]s
Carlos
www.firebirdnews.org - www.FireBase.com.br
Il 07/03/2016 17.28, Thomas Steinmaurer t...@iblogmanager.com
[firebird-support] ha scritto:
> Although not that flexible as an ad-hoc query, but perhaps your
> particular use case can be achieved with a selectable stored procedure
> ...
Thank you Thomas, I modified my query like this:
select
> I'm sure, IBReplicator does its job very well. I simply noted that V3 RC
> should
> be treated as not production-ready (like any other RC in Firebird's history),
> but perhaps the Firebird project philosophy changed.
It has not!
RC releases should not be used for production purposes.
> >
07.03.2016 17:21, Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
wrote:
>> > Nothing prevents him from installing of an additional server for
>> > report purposes and
>> >setting up replication to it from production one.
>
> Yeah. Sure. ;-)
>
Well, if setting up standby
> Il 07/03/2016 11.32, Dimitry Sibiryakov s...@ibphoenix.com
> [firebird-support] ha scritto:
>> sum(saldo) over (order by data)
>
> Thank You for your response but I can't do: sum(SALDO) because SALDO is
> not a field of my table.
>
> I badly explained myself: I have a table with only this
> 07.03.2016 12:55, 'Thomas Steinmaurer' t...@iblogmanager.com
> [firebird-support] wrote:
>> Needless to say, 3.0 is in release candidate state. Not sure if Luigi wants
>> to run 3.0 in
>> production yet. ;-)
>
> Nothing prevents him from installing of an additional server for report
>
07.03.2016 16:57, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
wrote:
> You think that users can spin up servers/replication on a whim to solve a
> problem in a
> deployed system???
A lot of them does so.
--
WBR, SD.
> > Needless to say, 3.0 is in release candidate state. Not sure if Luigi
> > wants to run 3.0 in production yet. ;-)
>
>Nothing prevents him from installing of an additional server for report
> purposes and setting up replication to it from production one.
Seriously!??
Do you read
On 2016-03-07 11:32, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 07.03.2016 11:16, Luigi Siciliano luigi...@tiscalinet.it
> [firebird-support] wrote:
>> How I do?
>
>sum(saldo) over (order by data)
That only works with Firebird 3.
Mark
07.03.2016 12:53, liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
wrote:
>
> Not so hurry.. FB3 is on RC2 stage not final.
According to the announce it is stable enough for reporting/OLAP server.
--
WBR, SD.
07.03.2016 12:55, 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
wrote:
> Needless to say, 3.0 is in release candidate state. Not sure if Luigi wants
> to run 3.0 in
> production yet. ;-)
Nothing prevents him from installing of an additional server for report
purposes and
> 07.03.2016 12:29, Luigi Siciliano luigi...@tiscalinet.it [firebird-support]
> wrote:
>> Ok, I understand but, "over" is unknow in firebird 2.5.5.
>
> Upgrade to 3.0.
Needless to say, 3.0 is in release candidate state. Not sure if Luigi wants to
run 3.0 in production yet. ;-)
--
With
> 07.03.2016 12:29, Luigi Siciliano luigi...@tiscalinet.it [firebird-support]
> wrote:
> > Ok, I understand but, "over" is unknow in firebird 2.5.5.
>
>Upgrade to 3.0.
>
> --
>WBR, SD.
Not so hurry.. FB3 is on RC2 stage not final.
regards,
Karol Bieniaszewski
07.03.2016 12:29, Luigi Siciliano luigi...@tiscalinet.it [firebird-support]
wrote:
> Ok, I understand but, "over" is unknow in firebird 2.5.5.
Upgrade to 3.0.
--
WBR, SD.
Il 07/03/2016 11.58, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] ha scritto:
> sum(carcio-scarcio) over () as SALDO.
Ok, I understand but, "over" is unknow in firebird 2.5.5.
I modified my query like this:
select
DT.DATA,
DT.DOCUMENTO_ID,
DT.NUMERO,
DT.SERIE,
07.03.2016 11:51, Luigi Siciliano luigi...@tiscalinet.it [firebird-support]
wrote:
> I need add SALDO fields in the result of the query to get a progressive
> sum of CARICO - SCARICO.
sum(carcio-scarcio) over () as SALDO.
--
WBR, SD.
Hallo,
Il 07/03/2016 11.32, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] ha scritto:
> sum(saldo) over (order by data)
Thank You for your response but I can't do: sum(SALDO) because SALDO is
not a field of my table.
I badly explained myself: I have a table with only this fields:
07.03.2016 11:16, Luigi Siciliano luigi...@tiscalinet.it [firebird-support]
wrote:
> How I do?
sum(saldo) over (order by data)
--
WBR, SD.
++
Hallo,
I need to write a query with a computed field that contain a
progressive sum like this table:
DATA DOCUMENTO_ID NUMERO SERIE CARICO SCARICO SALDO
01/01 A 1 A
10 1
02/01 A
21 matches
Mail list logo
