Re: ODP: [firebird-support] Using Union and Join (of two tables residing in different databases)in a Query

2018-09-14 Thread 'Stellarancia.com' ni...@stellarancia.com [firebird-support]
He, I'm agree with you: all tables in a unique firebird file is the best choice. My problem is that I've numerous programs that utilize one firebird file each. There are tables that are drawn for a specific program, but there are some tables that are "common" to all programs (example:

Re: [firebird-support] Two aliases pointing to the same file

2018-09-14 Thread Aldo Caruso aldo.car...@argencasas.com [firebird-support]
Thanks ! El 14/09/18 a las 06:11, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] escribió: On 13-9-2018 22:42, Aldo Caruso aldo.car...@argencasas.com [firebird-support] wrote: > Hello, > >     Is there any issue having two aliases pointing to the same physical > file ? > > Example: >

Re: [firebird-support] Using Union and Join (of two tables residing in different databases) in a Query

2018-09-14 Thread 'Stellarancia.com' ni...@stellarancia.com [firebird-support]
Dear Svein, the problem is not the greatness of the database, but its administration: the problem borns for a few tables that are utilized by others tables (master/detail), and for many records passed to "storical" (these movements become static). These tables don't have need to periodically

RE: [firebird-support] Re: Transaction access mode (read only vs. read write) from context?

2018-09-14 Thread Omacht András aoma...@mve.hu [firebird-support]
Hi Vlad! Thank you! Is it possible to backport this items to 2.5.9? András From: firebird-support@yahoogroups.com Sent: Wednesday, September 12, 2018 6:13 PM To: firebird-support@yahoogroups.com Subject: [firebird-support] Re: Transaction access mode (read only vs. read write) from context?

Re: [firebird-support] GBAK and NBAK restore

2018-09-14 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 13-9-2018 23:05, hugo.lar...@yahoo.com [firebird-support] wrote: > > >> Do you mean you increase the back up level continuously? > > Yes > My strategy is: > Level 0 once. > Increment level continuously every third Day. > > Works fine most of the times. Sometimes I get mysteriously the

Re: [firebird-support] GBAK and NBAK restore

2018-09-14 Thread hugo.lar...@yahoo.com [firebird-support]
Hi, Unfortunately 2.5 does not have replication. I'm desperately waiting for FB4. Thx,

Re: [firebird-support] Two aliases pointing to the same file

2018-09-14 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 13-9-2018 22:42, Aldo Caruso aldo.car...@argencasas.com [firebird-support] wrote: > Hello, > >     Is there any issue having two aliases pointing to the same physical > file ? > > Example: > > old_alias = /var/lib/firebird/2.5/data/mydb.fdb > > new_alias =

Re: [firebird-support] Two aliases pointing to the same file

2018-09-14 Thread Aldo Caruso aldo.car...@argencasas.com [firebird-support]
Thanks for your answer. I'm renaming aliases for code refactoring purposes, so during some transitional time some scripts and programs will be accessing via the old alias while others via the new one. I only wanted to know if under that situation the server still realizes that they both

ODP: [firebird-support] Using Union and Join (of two tables residing in different databases)in a Query

2018-09-14 Thread Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]
Hi, 1. Why not single Firebird database with all tables? 2. Why not recent Firebird which is FB3 not FB2.5? Pozdrawiam, Karol Bieniaszewski

Re: [firebird-support] Firebird 3.0 installation not allowing database access with strange errors-HELP!

2018-09-14 Thread Chuck Belanger phytot...@lanset.com [firebird-support]
For those who may be interested: After much work and exploration, it turns out that FreeUDFLib.dll requires gds32.dll installed into System32 folder. Turns out the pas files reference some Delphi Interbase pas files. In my previous installations installing gds32.dll was the default, but not