[firebird-support] Re: multiple embedded versions

28.02.2019 23:17, Issam Boughanmi wrote: > > i have managed to use the firebird embedded on the shared hosting by setting > the FIREBIRD_LOCK variable Why? This is not necessary. > but i dont know if it safe to use this setup that way It's safe as long as FIREBIRD_LOCK is defined as system varia

[firebird-support] Query optimization when using sub query with in operator

The following problem applies to Firebird 3.0. Cant test right now on older versions. Suppose we have a table called AnyTable with column ID as primary key. The query select * from AnyTable where ID = '123' produce the following plan... PLAN (AnyTable INDEX (PK_AnyTable)) Now a second query,

Re: [firebird-support] Question: RDB$SYSTEM_FLAG = 0 No Results

Thanks. I am familiar with using parameterized queries (Perl). All the same. Best regards On 2/28/2019 2:38 PM, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: On 28-2-2019 18:06, Robert Tulloch tult...@hughes.net [firebird-support] wrote: > Fixed: > >     GetUniqueStatisticsSt

[firebird-support] multiple embedded versions

hi, let's say that i have differents applications on different folders . each folder contain a firebird database and an embedded firebird dll . is it safe to use this setup knowing that all the embedded libraries will use the same *firebird lock directory* . the reason for this and not using a r

Re: [firebird-support] Question: RDB$SYSTEM_FLAG = 0 No Results

On 28-2-2019 18:06, Robert Tulloch tult...@hughes.net [firebird-support] wrote: > Fixed: > >     GetUniqueStatisticsStatement.Add(FORMAT('select Cast(%s AS > varchar(32))AS TABLE_NAME, cast(%s AS varchar(32)) AS INDEX_NAME, > cast(RDB$STATISTICS as varchar(32)) as RDB$STATISTICS',[tableName,

Re: [firebird-support] Question: RDB$SYSTEM_FLAG = 0 No Results

On 28-2-2019 02:02, Robert Tulloch tult...@hughes.net [firebird-support] wrote: > Hi: > >   I just ran this > > select 'MEMPAY1' AS TABLE_NAME, 'M1ID' AS INDEX_NAME, > cast(RDB$STATISTICS as varchar(32)) as RDB$STATISTICS from rdb$indices > where RDB$SYSTEM_FLAG is null > or RDB$SYSTEM_FLAG =

Re: [firebird-support] Question: RDB$SYSTEM_FLAG = 0 No Results

Fixed:     GetUniqueStatisticsStatement.Add(FORMAT('select Cast(%s AS varchar(32))AS TABLE_NAME, cast(%s AS varchar(32)) AS INDEX_NAME, cast(RDB$STATISTICS as varchar(32)) as RDB$STATISTICS',[tableName, indexName]));     GetUniqueStatisticsStatement.Add('from rdb$indices where (RDB$SYSTEM_FLA

Re: [firebird-support] Question: RDB$SYSTEM_FLAG = 0 No Results

On 2/28/2019 12:54 AM, hele...@iinet.net.au [firebird-support] wrote: ---In firebird-support@yahoogroups.com, wrote : On 2/27/2019 2:44 PM, Robert Tulloch tult...@hughes.net [firebird-support] wrote: Hi:   I just ran this select 'MEMPAY1' AS TABLE_NAME, 'M1ID

RE: [firebird-support] Connection lost after long inactive time

>> DummyPacketInterval = 0 (but this should be irrelevant for this type >> of issue) >Try to change it. This _is_ relevant for this type of issue. That did the trick. Thanks, Dimitry! Regards Stefan What did you change it to? Alan Posted by: Stefa

Re: [firebird-support] Connection lost after long inactive time

>> DummyPacketInterval = 0 (but this should be irrelevant for this type >> of issue) >Try to change it. This _is_ relevant for this type of issue. That did the trick. Thanks, Dimitry! Regards Stefan