[firebird-support] complicated recursion or other option?

2017-04-27 Thread 'Check_Mail' check_m...@satron.de [firebird-support]
Hello, in advance, many thanks! I would like to combine all properties like this: Property1 Property2 Property3 Property4.. IP54 Yellow With lamp 30W IP20 Blue Without l

Re: [firebird-support] Immediate Detection of Disconnected Clients on Classic

2017-04-27 Thread Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support]
On 25.04.2017 o 17:03, hv...@users.sourceforge.net [firebird-support] wrote: > [...] > I don't actually think Firebird can detect client disconnection > "immediately" when there is no data exchange between the server and the > client (it would require some kind of heartbeat increasing traffi

Re: [firebird-support] Re: FB3 - Limbo and consistency check

2017-04-27 Thread Gabor Boros mlngl...@bgss.hu [firebird-support]
2017. 04. 26. 16:44 keltezéssel, hv...@users.sourceforge.net [firebird-support] írta: >Hi Gabor > >Do you have reproducible example ? Could you send it to me (or > regiser at tracker), please ? I send a test case to your address in this minutes. Hope that helps. Gabor ---

[firebird-support] complicated recursion or other option?

2017-04-27 Thread 'Check_Mail' check_m...@satron.de [firebird-support]
Hello, in advance, many thanks! I would like to combine all properties like this: Property1 Property2 Property3 Property4.. IP54 Yellow With lamp 30W IP20 Blue Without l

Re: [firebird-support] Performing bulk update taking time.

2017-04-27 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
27.04.2017 9:03, 'Joje' j...@codework-solutions.com [firebird-support] wrote: > Is there a way through which this query can be further optimised as this > query taking time > for completion more than 3 -4 hours. Could I use batch based update in this > qu ery…? Query in FOR SELECT does not n

Re: [firebird-support] Firebird 2.5 - Alter table - drop default - bug or feature

2017-04-27 Thread Lester Caine les...@lsces.co.uk [firebird-support]
On 26/04/17 16:34, Ann Harrison aharri...@ibphoenix.com [firebird-support] wrote: > If Firebird were to convert a record from its stored format through each > intervening format, the result would be more logical but it would be a change > to a behavior that's over 30 years old. And there are adva

Re: [firebird-support] Firebird 2.5 - Alter table - drop default - bug or feature

2017-04-27 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
> Apr 25, 2017, at 12:21 PM, Lester Caine les...@lsces.co.uk > [firebird-support] wrote: > > On 25/04/17 16:50, Mark Rotteveel m...@lawinegevaar.nl > [firebird-support] wrote: >> The SQL standard is quite clear at what needs to happen: adding a new >> column with a default should behave as if

Re: [firebird-support] Performing bulk update taking time.

2017-04-27 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 27-4-2017 09:03, 'Joje' j...@codework-solutions.com [firebird-support] wrote: > Is there anyway using which we could perform bulk update in firebird. > > I have two tables A & B. Both tables are referenced by a *varchar(100)* > *AR_ID* column. > > - Total number of rows in each table

[firebird-support] Performing bulk update taking time.

2017-04-27 Thread 'Joje' j...@codework-solutions.com [firebird-support]
Hello everyone, Is there anyway using which we could perform bulk update in firebird. I have two tables A & B. Both tables are referenced by a varchar(100) AR_ID column. - Total number of rows in each table is around 1 million. Now in order to get faster result I created a bigint