ericthereddish wrote:

>--- 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
>
>
>
>

Eric,

Any chance that when you use local connection be using FB 1.5 embedded
and when connecting using TCP/IP connecting to a FB 1.0 ?

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br