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]