ODP: [firebird-support] Firebird schema questions

hi, odbc is a standard connection layer for many databases. It contain then many features not supportet by every rdbms. And schemas is one of them. regards,Karol Bieniaszewski Oryginalna wiadomość Od: "heineferre...@yahoo.com [firebird-support]"

[firebird-support] UDF install in FB3.0 RC2

I have a FB 2.5.5 database which I have migrated to FB3 RC2. I use the older FreeUDFLib.dll. All the procedures of this DLL are in the database reported by Database Workbench 5. The restore log for the migration shows no errors. This DLL is in the FB 3 UDF folder. When running a stored

Re: [firebird-support] How write a query with a progressive sum field

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

Re: [firebird-support] How write a query with a progressive sum field

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

RE: [firebird-support] How write a query with a progressive sum field

> 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. > >

Re: [firebird-support] How write a query with a progressive sum field

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

Re: [firebird-support] How write a query with a progressive sum field

> 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

Re: [firebird-support] How write a query with a progressive sum field

> 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 >

Re: [firebird-support] How write a query with a progressive sum field

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.

RE: [firebird-support] How write a query with a progressive sum field

> > 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

[firebird-support] Firebird schema questions

Hi, What is a schema and how do I use it? I saw in the odbc driver settings they mention schemas. Thanks Heine

Re: [firebird-support] How write a query with a progressive sum field

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

Re: [firebird-support] How write a query with a progressive sum field

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.

Re: [firebird-support] How write a query with a progressive sum field

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

Re: [firebird-support] How write a query with a progressive sum field

> 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

Re: Re: [firebird-support] How write a query with a progressive sum field

> 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

Re: [firebird-support] How write a query with a progressive sum field

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.

Re: [firebird-support] How write a query with a progressive sum field

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,

[firebird-support] Slow query with FB 2.5.5 - Why ?

Hi, I'm using FB 2.5.5 CS under Windows 8.1. Selectivity of indices has been updated before asking for help :) I'm trying to optimize the following query : UPDATE TVERSIONS v1 SET ... WHERE RD_BACKUPID=:BackupID AND NOT EXISTS (SELECT 1 FROM TVERSIONS v2 WHERE

Re: [firebird-support] How write a query with a progressive sum field

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.

Re: [firebird-support] How write a query with a progressive sum field

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:

Re: [firebird-support] How write a query with a progressive sum field

07.03.2016 11:16, Luigi Siciliano luigi...@tiscalinet.it [firebird-support] wrote: > How I do? sum(saldo) over (order by data) -- WBR, SD. ++

Re: [firebird-support] Re: query to return the last entry in detail table for each entry in master table

Hi,   i suppose that you sholuld change r.review_date > r2.review_date   to   r.review_date < r2.review_date   regards, Karol Bieniaszewski   W dniu 2016-03-07 11:02:35 użytkownik talorigo...@yahoo.co.uk [firebird-support] napisał:   Hi Set   Thanks for helping

[firebird-support] How write a query with a progressive sum field

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

[firebird-support] Re: query to return the last entry in detail table for each entry in master table

Hi Set Thanks for helping me with this. Your answer has been a great help. However there is a problem with the result set. In the Assignment table I have the following data: (of interest is assignid 9 which is projectid 19) ASSIGNID ASSIGN_DATE MANAGER PROJECTID 1 03/03/2016 11 2

AW: [firebird-support] differences between firebird 2.5 cs and 3.0 rc2 ss

Many Thanks, Ann :) Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Gesendet: Samstag, 5. März 2016 20:29 An: firebird-support@yahoogroups.com Betreff: Re: [firebird-support] differences between firebird 2.5 cs and 3.0 rc2 ss On Fri, Mar 4, 2016 at