Subject Re: [firebird-support] Firebird 2.1.1, error when execute an Select statment with UDF function under Windows 2008 x64
Author Huan Ruan
Firebird SQL requires a Table, View, or a Selectable Stored Procedure
following the 'FROM', while abs is a function.

To achieve the same, you could try
select abs(-2.3) from rdb$database

2009/1/14 Charles-Henri Balet <charles-henri@...>

> Hello,
> I have installed an Windows x64 with the Firebird 2.1.1 32 bits version
> (because I haven't compiled my udf under 64 bits now)
> when I use Ibexpert for send this command to Firebird "select * from
> abs(-2.3)" I obtain an error :
> Undefined name.
> Dynamic SQL Error.
> SQL error code = -204.
> Procedure unknown.
> ABS.
> At line 1, column 20.
> the same function used in a compiled stored procedure work fine .... this
> error is same for all udf I want to use directly
> any body can help me please
> I have try to install in superserver and classic mode, 32 and 64 bits, all
> result are the same ...
> this error is the same trhough my application when I wan to call directly
> an select with an UDF inside not only
> from Ibexpert
> many thanks
> chb
> [Non-text portions of this message have been removed]

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