--- In firebird-support@yahoogroups.com, "Adam" <s3057043@y...> wrote:

>
> --- In firebird-support@yahoogroups.com, "ericthereddish" <e2@h...>
> wrote:
> >
> > I have installed firebird 1.5.
> > When I log in via TCP/IP (to localhost)the new functions like COALESCE
> > and CASE statements are not recognised. I get a message like:
> > SQL error code = -804.
> > Function unknown.
> > COALESCE.
> >
> > However when I connect locally these functions work fine.
> > I downloaded the latest release 1.5.2 and installed under XP sp2
> > without any customisation. Setup with the superserver option. This
> > problem occurs both in the sample
> > "employee" database as well as other ones.
> >
>
> I am not too sure what you are doing. Post an example if you want help.
>
> the syntax that works on 1.5.2 is
>
> select coalesce(fieldname, 0) from table
>
> or
>
> select coalesce(fieldname, 'blah') from table
>
> It works via whatever connection method you use in whatever platform
> you use. Are you using isql or something else? If isql, are you sure it
> is connected? SP2 has a firewall enabled which may well block isql or
> the service from accepting connections.
>
> Adam
>

Well i'm using my own delphi program, but same problem in isql
On the sample database:
select coalesce(job_code, 'blah') from job;

produces the error
while:
select job_code from job;

works just fine. So yes I'm definitely connected.

The problem only occurs when I connect as follows:
SQL> connect 'localhost:C:\Program
Files\Firebird\Firebird_1_5\examples\EMPLOYEE
.FDB' user sysdba password masterkey;

if I connect locally as follows:
SQL> connect 'C:\Program Files\Firebird\Firebird_1_5\examples\EMPLOYEE
.FDB' user sysdba password masterkey;

the coalesce works fine

So I'm really puzzled.

Eric