Re: [firebird-support] My cliient can only connect to a Firebird DB when IBOConsole has connected

On 7-5-2018 17:04, B?lint Nagy bali...@hotmail.com [firebird-support] wrote: > Fb Server version is WI-V2.0.3.12981 Firebird 2.0 > > Any ideas? Is your other application maybe connecting as Firebird Embedded instead of through Firebird server? That could explain the difference in behavior,

[firebird-support] My cliient can only connect to a Firebird DB when IBOConsole has connected

Hi, I have an app (App1) installed in about 5 locations. It uses a Firebird database, that is also used by another app (App2). In one location, App1 can't connect to the DB, while App2 can. I ran some tests, here are the results: App2 is connected and working. App1 can NOT access the DB. I start

Re: [firebird-support] Strange SIMILAR TO result

2018. 05. 07. 14:46 keltezéssel, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] írta: > 07.05.2018 13:57, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote: >> So I see what you say. But result of >> >> SELECT CAST(''='' AS CHAR(5)) SIMILAR TO '[A-Z]{2}[0-9A-Z]{2,13}' FROM >>

Re: [firebird-support] Strange SIMILAR TO result

Ach now it is clear. All work ok. You got false for char(5) because it work the same way as it is working for LIKE with char.  TrySelect cast('ABCD' as char(5)) like 'ABCD' from rdb$database Regards,Karol Bieniaszewski null

Re: [firebird-support] Strange SIMILAR TO result

2018. 05. 07. 14:31 keltezéssel, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] írta: > Hi, > > It is false for me > But i put '=' in single quote with double it does not work. I use > FB3.0.4.32954 dialect 3 Nothing double quote. ''='' is a boolean expression, empty string equal

Re: [firebird-support] Deactivate triggers inside EXECUTE BLOCK

thanks On Monday, May 7, 2018, 12:43:40 PM GMT+3, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 07.05.2018 7:43, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > I'm looking for a way to run a simple update on couple tables

Re: [firebird-support] Strange SIMILAR TO result

07.05.2018 13:57, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote: > So I see what you say. But result of > > SELECT CAST(''='' AS CHAR(5)) SIMILAR TO '[A-Z]{2}[0-9A-Z]{2,13}' FROM > RDB$DATABASE; > > is > > === > Perhaps, it must be CHAR(4) or VARCHAR. I'm not sure in type of

Re: [firebird-support] Strange SIMILAR TO result

Hi, It is false for meBut i put '=' in single quote with double it does not work. I use FB3.0.4.32954 dialect 3 Regards,Karol Bieniaszewski null

Re: [firebird-support] Strange SIMILAR TO result

2018. 05. 07. 12:26 keltezéssel, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] írta: > 07.05.2018 12:19, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote: >> A simple example: SELECT ''='' SIMILAR TO '[A-Z]{2}[0-9A-Z]{2,13}' FROM >> RDB$DATABASE >> >> Why is the result true? > >

Re: [firebird-support] Strange SIMILAR TO result

07.05.2018 12:19, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote: > A simple example: SELECT ''='' SIMILAR TO '[A-Z]{2}[0-9A-Z]{2,13}' FROM > RDB$DATABASE > > Why is the result true? Your expression is actually calculated as "CAST(''='' as CHAR(5)) SIMILAR TO

[firebird-support] Strange SIMILAR TO result

Hi All, I accidentally (copy/paste :-) ) make a wrong SELECT which give back strange (true) result for me. A simple example: SELECT ''='' SIMILAR TO '[A-Z]{2}[0-9A-Z]{2,13}' FROM RDB$DATABASE Why is the result true? I use 3.0.3. Gabor

Re: [firebird-support] Deactivate triggers inside EXECUTE BLOCK

07.05.2018 7:43, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > I'm looking for a way to run a simple update on couple tables without calling > triggers Modify your trigger to check some context variable and skip actions. Then do something like that: EXECUTE BLOCK AS declare

[firebird-support] Re: nbackup - Problem on "attach database"

You are right. The IBExpert connection was set to local. Is it better to use always a remote connection (with loopback)? We already changed the settings in IBExpert to the loopback connection, because we had some other issues while trying to connect to the database from two PCs at the same

Re: [firebird-support] Proper way to handle an open Firebird database...

> Besides that, is there any other advantage of gbak or nbackup > against an ordinary copy of the database? When a GBAK backup finishes successfully you know that your database is physically intact. When a restore finishes successfully you also know that your database is logically intact