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 a

where a.dispo = 0 and a.gesperrt = 0 and a.elementtyp = 1 and
a.paltyp = :paltyp

and a.le is not null

and (select count (*) from tlepos where bestandsnr is not null and
leid = a.le) = 4

and iif((select count(*) from tfachres where artnr = :artnr) >0,
'a.dispo = 0', 'bestandsnr is null')



My second question is more complicated.



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 connect to our database by starting! The
specified one task of fbserver (we are using classic) takes a lot of cpu
capacity and the new task never ends. At this moment, we are also cannot
work with ibexpert. If we close the hanging one task and close ibexpert, the
other clients can connect to the fdb.



One of the additional tast is an isql-script wich stardet a stored
procedure. The script is started by the windows scheduler every 5 minutes.
If ibexpert is open, it can be that the dos-command-prompt remains opened
and will never closed.



How can we solve that problem? I think there are no limits like the
connections to firebird?



Thank you in advance.



Best regards



Olaf





[Non-text portions of this message have been removed]