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]"
Data: 07.03.2016 14:44
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 procedure
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
On 07/03/16 17:10, 'Leyne, Sean' s...@broadviewsoftware.com
[firebird-support] wrote:
>> 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 release
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.
> >
> > I need add SALDO fields in the result of the query to get a
> > progressive sum of CARICO - SCARICO.
>
> Although not that flexible as an ad-hoc query, but perhaps your particular
> use case can be achieved with a selectable stored procedure ...
A similar solution, one which could support s
On 07.03.2016 17:40, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 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 replic
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 ser
> 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 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
> purp
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 you
Hi,
What is a schema and how do I use it?
I saw in the odbc driver settings they mention schemas.
Thanks
Heine
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
set
> 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 regar
> 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,
DC
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
v2.FILEID=
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.
++
Visi
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 me with this. Your answer has been
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
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
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 3:22
29 matches
Mail list logo