At 09:11 PM 24/09/2011, SET wrote:
>I've never used classic at all, so what I write here may not be correct! If
>you have two processors and have set the CPU affinity to use just one of them
>(the benefit with classic would normally be that you can use several
>processors, but maybe it still a
> I have check that. First, we have closed an application "A". After this,
> the 5-minutely executing isql-script does not work and hangs (dos-box) The
> transactions stops! Oldest for example 50 and next 51, a difference
> of 1 but next transaction does not count continuous. The differ
Olaf,
>
> I have check that. First, we have closed an application "A". After this,
> the
> 5-minutely executing isql-script does not work and hangs (dos-box) The
> transactions stops! Oldest for example 50 and next 51, a difference
> of 1 but next transaction does not count continuous.
Olaf,
> we are using firebird 2.5 classic server 64 bit on windows server 2008
> standard 64 bit.
>
>
> Some clients (max. 5) are connected to our database. All of them close some
> transactions. But we using ibexpert. Now if we have some tables opened in
> IBEXPERT, some other clients cannot con
> and (
> (select count(*) from tfachres where artnr = :artnr) > 0
> and a.dispo = 0
> or coalesce((select count(*) from tfachres where artnr = :artnr), 0) <= 0
> and bestandsnr is null
> )
>
> Not sure if the query optimizer is smart enough to eval the count
> subquery only once.
Why
Olaf Kluge skriver:
> Hello,
>
> we are using firebird 2.5 classic server 64 bit on windows server 2008
> standard 64 bit.
>
> My first question. Is the last line possible? (iif(select condition =
> true,'where field = value','where field = value2)
>
> select first (1) a.fachnr, a.le
> from tfachzu
Hello,
we are using firebird 2.5 classic server 64 bit on windows server 2008
standard 64 bit.
My first question. Is the last line possible? (iif(select condition =
true,'where field = value','where field = value2)
select first (1) a.fachnr, a.le
from tfachzuordnung