2011/9/21 johnbmoore
> Anyone have luck on this one..
>
use Firebird 2.5.1
http://www.ibphoenix.com/download/firebird/prerelease
Firebird 2.1.4 was built and tested under MacOsx 10.6 not 10.7
MacOsx 10.7 was released on July 20, 2011
Firebird 2.1.4 was released on Mar 15, 2011
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
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
> 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
Found the answer
Read Paul Beach's blog article and found the new build...
(Just wanted to leave that here so it might shorten the search for the solution
for someone else..)
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
I'm building a little scheduler, with FB 2.5 as my DB. For reasons which I
will not get into, the design I went with is to create a table that contains
nothing more than a list of minutes in a given 24 hour day and an "Available"
flag. The table DDL is as follows:
CREATE TABLE MINUTE_LIST
(
Den 2011-09-22 04:48 skrev red_october2009 såhär:
> I'm building a little scheduler, with FB 2.5 as my DB. For reasons which
> I will not get into, the design I went with is to create a table that
> contains nothing more than a list of minutes in a given 24 hour day and
> an "Available" flag. The
I want to use firebird on C# project. So I had test .net provider by below
steps.
1. create database
2. open database
3. close database
4. drop database
I saw the error message while try to drop database.
What I have to do for delete the database.
following code & result message is mine.
--